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] |