KB003227
PRODUCT: K2 Five 5.3
K2 blackpearl 4.7
This article lists the differences between the K2 4.7 and K2 Five (5.3) databases in terms of Tables" Views and Stored Procedures. You can scroll through the content or use your browser's CTRL+F search function to find the item you want to check.
This article only lists the names of tables views and stored procedures in both versions' K2 databases. If you need to compare schema or other differences between artifacts in the databases (for example comparing the columns in a specific table) you can use SQL management tools to generate scripts for the specific artifacts that you want to investigate from the different K2 environments and then compare the scripts.
If necessary you can install K2 Five with an evaluation license to generate the K2 Five databases and then generate K2 Five scripts from that evaluation environment.
Clicking on the table header row sorts the table by that column. Because of the amount of data in the table sorting can take a few minutes to complete.
Tables
Table Name | K2 4.7 | K2 5.3 |
[HostServer].[Session] | ✓ | |
[HostServer].[Stream] | ✓ | |
[Identity].[RoleItem] | ✓ | |
[Identity].[tmp_IdentityAudit] | ✓ | |
[Identity].[tmp_IdentityToResolve] | ✓ | |
[SmartBroker].[ApplicationMap] | ✓ | |
[SmartBroker].[Application] | ✓ | |
[AppWizard].[Administrator] | ✓ | |
[AppWizard].[AppReference] | ✓ | |
[AppWizard].[AppSetting] | ✓ | |
[AppWizard].[ApplicationBuilder] | ✓ | |
[AppWizard].[ApplicationHeader] | ✓ | |
[AppWizard].[ApplicationTemplate] | ✓ | |
[AppWizard].[ApplicationType] | ✓ | |
[AppWizard].[ApprovalParticipant] | ✓ | |
[AppWizard].[Comment] | ✓ | |
[AppWizard].[DataListOptionTemplate] | ✓ | |
[AppWizard].[DataListOption] | ✓ | |
[AppWizard].[DataSourceFieldTemplate] | ✓ | |
[AppWizard].[DataSourceField] | ✓ | |
[AppWizard].[DataSourceTemplate] | ✓ | |
[AppWizard].[DataSource] | ✓ | |
[AppWizard].[DataTypeOption] | ✓ | |
[AppWizard].[DataType] | ✓ | |
[AppWizard].[DebugLog] | ✓ | |
[AppWizard].[Icon] | ✓ | |
[AppWizard].[LookupObjectValueTemplate] | ✓ | |
[AppWizard].[LookupObjectValue] | ✓ | |
[AppWizard].[MasterDetailOptionTemplate] | ✓ | |
[AppWizard].[MasterDetailOption] | ✓ | |
[AppWizard].[SurveyOptionTemplate] | ✓ | |
[AppWizard].[SurveyOption] | ✓ | |
[AppWizard].[WorkflowApprovalTemplate] | ✓ | |
[AppWizard].[WorkflowApproval] | ✓ | |
[AppWizard].[WorkflowTemplate] | ✓ | |
[Authorization].[RoleMember] | ✓ | |
[Authorization].[Role] | ✓ | |
[Badger].[IdentityLink] | ✓ | |
[Badger].[IdentityPropertyMapping] | ✓ | |
[Badger].[IdentityProperty] | ✓ | |
[Badger].[Identity] | ✓ | |
[Badger].[RegisteredInstance] | ✓ | |
[Badger].[SyncStatus] | ✓ | |
[Deployment].[DeploymentResource] | ✓ | |
[Deployment].[Deployment] | ✓ | |
[Deployment].[ModelItemDeployment] | ✓ | |
[Deployment].[ModelItemStatus] | ✓ | |
[Deployment].[ModelItem] | ✓ | |
[Deployment].[Resource] | ✓ | |
[Deployment].[Session] | ✓ | |
[Deployment].[Settings] | ✓ | |
[Designer].[CollabData] | ✓ | |
[Designer].[CollabSeenInstructions] | ✓ | |
[Designer].[ContextHash] | ✓ | |
[Designer].[CustomEnvironmentWizardCategory] | ✓ | |
[Designer].[CustomEnvironmentWizard] | ✓ | |
[Designer].[CustomShape] | ✓ | |
[Designer].[CustomWizardAccess] | ✓ | |
[Designer].[CustomWizardCategoryList] | ✓ | |
[Designer].[CustomWizardCategory] | ✓ | |
[Designer].[CustomWizard] | ✓ | |
[Designer].[EnvironmentWizardCategory] | ✓ | |
[Designer].[EnvironmentWizard] | ✓ | |
[Designer].[Environment] | ✓ | |
[Designer].[FavoriteTypes] | ✓ | |
[Designer].[Favorite] | ✓ | |
[Designer].[Hash] | ✓ | |
[Designer].[ProcessFunctions] | ✓ | |
[Designer].[ProcessHistory] | ✓ | |
[Designer].[Process] | ✓ | |
[Designer].[Shape] | ✓ | |
[Designer].[SharingDetail] | ✓ | |
[Designer].[Sharing] | ✓ | |
[Designer].[UserOptionTipType] | ✓ | |
[Designer].[UserOptionTip] | ✓ | |
[Designer].[UserOption] | ✓ | |
[Designer].[WizardAccess] | ✓ | |
[Designer].[WizardCategoryList] | ✓ | |
[Designer].[WizardCategory] | ✓ | |
[Designer].[Wizard] | ✓ | |
[HostServer].[Feature] | ✓ | |
[HostServer].[ServerAllocation] | ✓ | |
[Identity].[BadgerLinkKey] | ✓ | |
[Identity].[BadgerLinkProvider] | ✓ | |
[Identity].[BadgerLinkSyncStatus] | ✓ | |
[Identity].[IdentityAudit] | ✓ | |
[Identity].[IdentityToResolve] | ✓ | |
[ServerLog].[ActOutcome] | ✓ | |
[Server].[ActOutcome] | ✓ | |
[Server].[ProcInstItemState] | ✓ | |
[Server].[ProcSetConfig] | ✓ | |
[SmartBoxData].[City] | ✓ | |
[SmartBoxData].[Countries] | ✓ | |
[SmartBoxData].[Countries_1] | ✓ | |
[SmartBoxData].[Regions] | ✓ | |
[SmartBroker].[ServiceObjectAssociation] | ✓ | |
[SmartBroker].[ServiceObjectMethodParameter] | ✓ | |
[SmartBroker].[ServiceObjectMethod] | ✓ | |
[SmartBroker].[ServiceObjectProperty] | ✓ | |
[SmartBroker].[SmartObjectMethodExecutionBlockMapping] | ✓ | |
[SmartBroker].[SmartObjectMethodExecutionBlock] | ✓ | |
[SmartBroker].[SmartObjectMethodParameter] | ✓ | |
[SmartBroker].[SmartObjectMethod] | ✓ | |
[SmartBroker].[SmartObjectProperty] | ✓ | |
[Smartbox].[PolicyRlsGeneratedEntity] | ✓ | |
[Smartbox].[PolicySmartObject] | ✓ | |
[Smartbox].[Policy] | ✓ | |
[SyncEngine].[IdentityLinkKey] | ✓ | |
[SyncEngine].[IdentityLink] | ✓ | |
[SyncEngine].[IdentityProperty] | ✓ | |
[SyncEngine].[Identity] | ✓ | |
[SyncEngine].[ProviderInstanceRuntimeConfig] | ✓ | |
[SyncEngine].[ProviderInstance] | ✓ | |
[SyncEngine].[ProviderObjectPropertyMapping] | ✓ | |
[SyncEngine].[ProviderObjectPropertyType] | ✓ | |
[SyncEngine].[ProviderObjectProperty] | ✓ | |
[SyncEngine].[ProviderObject] | ✓ | |
[SyncEngine].[ProviderType] | ✓ | |
[SyncEngine].[Provider] | ✓ | |
[SyncEngine].[RepositoryConfig] | ✓ | |
[SyncEngine].[RunHistory] | ✓ | |
[SyncEngine].[_IdentityAudit] | ✓ | |
[SyncEngine].[__EFMigrationsHistory] | ✓ | |
[WebAPI].[CORSSetting] | ✓ | |
[WebAPI].[CORSType] | ✓ | |
[WebAPI].[PublishedObject] | ✓ | |
[WebAPI].[ServiceObjectPermission] | ✓ | |
[WebAPI].[Setting] | ✓ | |
[WebAPI].[Token] | ✓ | |
[Workspace].[WorkspaceSite_Dashboard] | ✓ | |
[Workspace].[WorkspaceSite_NavigationConfigurationData] | ✓ | |
[Workspace].[WorkspaceSite_NavigationConfigurationTypeData] | ✓ | |
[Workspace].[WorkspaceSite_NavigationDefaultWorkspaceData] | ✓ | |
[Workspace].[WorkspaceSite_NavigationLinkData] | ✓ | |
[Workspace].[WorkspaceSite_NavigationLinkStyleData] | ✓ | |
[Workspace].[WorkspaceSite_NavigationSchemeData] | ✓ | |
[Workspace].[WorkspaceSite_NavigationTargetTypeData] | ✓ | |
[Workspace].[WorkspaceSite_RecentListForUser] | ✓ | |
[Workspace].[WorkspaceSite_Setting] | ✓ | |
[dbo].[SchemaVersions] | ✓ | |
[dbo].[SmartForms_Tester___Icons] | ✓ | |
[dbo].[SmartForms_Tester___Test_Case_Suites] | ✓ | |
[dbo].[SmartForms_Tester___Test_Cases] | ✓ | |
[dbo].[SmartForms_Tester___Test_Plans] | ✓ | |
[dbo].[SmartObjects_WebEndpointPublishing_Management_Icons_2] | ✓ | |
[dbo].[Workspace_Site_ProcessDataType] | ✓ | |
[dbo].[Workspace_Sites_Reports_ChartPeriods] | ✓ | |
[dbo].[Workspace_Sites_Reports_DateRangeFilters] | ✓ | |
[dbo].[com_K2_App_Framework_Core_SmartObject_AppSettingGroup] | ✓ | |
[dbo].[com_K2_App_Framework_Core_SmartObject_AppType] | ✓ | |
[dbo].[com_K2_App_Framework_Core_SmartObject_RegisteredAppFormType] | ✓ | |
[dbo].[com_K2_App_Framework_Core_SmartObject_RegisteredAppForm] | ✓ | |
[dbo].[com_K2_App_Framework_Core_SmartObject_RegisteredApp] | ✓ | |
[dbo].[com_K2_App_Framework_Core_SmartObject_VersionDetail] | ✓ | |
[dbo].[com_K2_App_Framework_Extension_GeneralNotification_SmartObject_Detail] | ✓ | |
[dbo].[com_K2_App_Framework_Extension_GeneralNotification_SmartObject_User] | ✓ | |
[dbo].[com_K2_System_Reports_SmartObjects_TermsConditions] | ✓ | |
[dbo].[com_K2_System_Workspace_SmartObject_ImageLibrary] | ✓ | |
[Authorization].[Action] | ✓ | ✓ |
[Authorization].[AuditLog] | ✓ | ✓ |
[Authorization].[ClassACL] | ✓ | ✓ |
[Authorization].[Class] | ✓ | ✓ |
[Authorization].[OAuthAppOnlyToken] | ✓ | ✓ |
[Authorization].[OAuthIdentity] | ✓ | ✓ |
[Authorization].[OAuthResourceParameter] | ✓ | ✓ |
[Authorization].[OAuthResourceTypeParameter] | ✓ | ✓ |
[Authorization].[OAuthResourceType] | ✓ | ✓ |
[Authorization].[OAuthResourceValue] | ✓ | ✓ |
[Authorization].[OAuthResource] | ✓ | ✓ |
[Authorization].[OAuthServiceSync] | ✓ | ✓ |
[Authorization].[OAuthSessionState] | ✓ | ✓ |
[Authorization].[OAuthTokenReplacementValue] | ✓ | ✓ |
[Authorization].[OAuthToken] | ✓ | ✓ |
[Authorization].[ObjectACL] | ✓ | ✓ |
[Authorization].[Object] | ✓ | ✓ |
[Authorization].[SessionUser] | ✓ | ✓ |
[Category].[Category] | ✓ | ✓ |
[Category].[DataType] | ✓ | ✓ |
[Category].[Data] | ✓ | ✓ |
[Category].[System] | ✓ | ✓ |
[CustomUM].[Group] | ✓ | ✓ |
[CustomUM].[UserGroup] | ✓ | ✓ |
[CustomUM].[User] | ✓ | ✓ |
[Dependency].[Class] | ✓ | ✓ |
[Dependency].[Dependency] | ✓ | ✓ |
[Designer].[ProcessEventAccess] | ✓ | ✓ |
[Designer].[ProcessEventCategoryEvent] | ✓ | ✓ |
[Designer].[ProcessEventCategory] | ✓ | ✓ |
[Designer].[ProcessEventExtendType] | ✓ | ✓ |
[Designer].[ProcessEventType] | ✓ | ✓ |
[Designer].[ProcessEvent] | ✓ | ✓ |
[Designer].[ProcessExtendedEventCategoryEvent] | ✓ | ✓ |
[Designer].[ProcessExtendedEventCategory] | ✓ | ✓ |
[Designer].[ProcessExtendedEvent] | ✓ | ✓ |
[Designer].[ProcessFavoriteGroupUser] | ✓ | ✓ |
[Designer].[ProcessFavoriteGroup] | ✓ | ✓ |
[Designer].[ProcessFavoriteType] | ✓ | ✓ |
[Designer].[ProcessFavorite] | ✓ | ✓ |
[Designer].[ProcessFavoritesUser] | ✓ | ✓ |
[Designer].[ProcessIPC] | ✓ | ✓ |
[Designer].[ProcessPluginImplementation] | ✓ | ✓ |
[Designer].[ProcessPluginType] | ✓ | ✓ |
[Designer].[ProcessPlugin] | ✓ | ✓ |
[Designer].[ProcessProcessTemplateGroupTemplate] | ✓ | ✓ |
[Designer].[ProcessProcessTemplateGroup] | ✓ | ✓ |
[Designer].[ProcessProcessTemplate] | ✓ | ✓ |
[Designer].[ProcessSharingDetail] | ✓ | ✓ |
[Designer].[ProcessSharing] | ✓ | ✓ |
[Designer].[ProcessSmartObjectMethodCategory] | ✓ | ✓ |
[Designer].[ProcessSmartObjectMethodProperty] | ✓ | ✓ |
[Designer].[ProcessSmartObjectMethod] | ✓ | ✓ |
[Designer].[ProcessTemplate] | ✓ | ✓ |
[Designer].[ProcessWelcomePage] | ✓ | ✓ |
[Designer].[ProcessXMLHistory] | ✓ | ✓ |
[Designer].[ProcessXML] | ✓ | ✓ |
[EnvironmentServices].[Platform] | ✓ | ✓ |
[EnvironmentServices].[SettingMap] | ✓ | ✓ |
[EnvironmentServices].[SettingValue] | ✓ | ✓ |
[EnvironmentServices].[Setting] | ✓ | ✓ |
[EnvironmentServices].[User] | ✓ | ✓ |
[Environment].[Environment] | ✓ | ✓ |
[Environment].[FieldType] | ✓ | ✓ |
[Environment].[FieldValue] | ✓ | ✓ |
[Environment].[Field] | ✓ | ✓ |
[Environment].[LogOperation] | ✓ | ✓ |
[Environment].[Log] | ✓ | ✓ |
[Environment].[Plugin] | ✓ | ✓ |
[Environment].[Template] | ✓ | ✓ |
[Eventbus].[ClientRecorderError] | ✓ | ✓ |
[Eventbus].[Config] |