Database differences between K2 blackpearl and K2 Five

  • 19 January 2023
  • 0 replies
  • 141 views

Userlevel 5
Badge +20

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]

   

 


0 replies

Be the first to reply!

Reply