Introduction

The K2 Database Consolidation Tool is used to consolidate multiple K2 databases into a single database. Prior to K2 blackpearl 4.6, multiple databases on the same SQL instance were created during the installation of K2 blackpearl.

With clean installs of 4.6 and later, a single database is created. If previous versions are upgraded to 4.6 or later, the multiple databases are upgraded but not consolidated. This tool is used to consolidate the existing multiple K2 databases into a single K2 database.

Prerequisites

  • The tool must be run on the SQL server that currently contains the K2 product databases.
  • The tool is compatible with K2 blackpearl and K2 smartforms versions per the following Release Compatibility table. The installed versions for K2 products can be found via Programs and Features in Control Panel.
  • The tool should be run by a user with System Administration (sysadmin) rights on the SQL Server.
  • The tool is compatible with the SQL Server versions supported by the K2 blackpearl version supported. For more information, please view the Compatibility Matrix: http://help.k2.com/en/blackpearlmatrix.aspx#SQLServer
  • The tool requires free space on the SQL Server equal to (current size of all K2 databases + current size of all K2 databases SQL logs) x 2.

  • The K2 connect database is not part of consolidation.  Additionally, K2 connect will not require any re-configuration after you have consolidated a K2 database.
  • If your K2 environment still uses multiple databases (also known as legacy databases), K2 recommends that you consolidate the databases in K2 4.6.11.
  • A prerequisite for upgrading to K2 4.7 is that the K2 environment uses a single database. If your K2 environment still uses multiple databases, you will need to consolidate your database before you will be able to upgrade to K2 4.7.
  • If consolidating after installing 4.6.11, the minimum version required is  4.6.11.1 (4.12060.1731.1). If you have already installed 4.6.11, you can use the K2 Update Manager 4.6.11.1 available on the K2 Partner and Customer Portal.

Release Compatibility
Currently Installed
K2 Product Version
K2 Database Consolidation Tool Version
1.9 1.8 1.7 1.6 1.5 1.4 1.3 1.2 1.1 1.0
K2 blackpearl
4.6.5 check check check check check check check check check check
4.6.6 check check check check check check check check check
4.6.7 check check check check check check
4.6.8 check check check check check
4.6.9 check check check check
4.6.10 check check check
4.6.11.1 check check
K2 smartforms
1.0.1 check
1.0.2 check check check check check check check check check check
1.0.3 check check check check check check check check check
1.0.4 check check check check check check check check
1.0.5 check check check check check check check
1.0.6 check check check check check check
1.0.7 check check check check check
4.6.9 check check check check
4.6.10 check check check
4.6.11.1 check check
K2 Package and Deployment
1.0 (4.13210.1.0) check check check check check check check check check check
K2 for SharePoint (2013)
1.0
1.0.1 check check check check check
4.6.9 check check check check
4.6.10 check check check
4.6.11 check check

Additional Information

For additional information including how to install and steps to use the K2 Database Consolidation Tool, important considerations for large databases or multiple domain configurations, as well as how to reduce the size of your databases through archiving, please see the attached K2 Database Consolidation Tool white paper ( 14 pages).

Accessing the Tool

You can download the latest version of the K2 Database Consolidation tool on the Partner and Customer Portal at https://portal.k2.com/products/k2dbconsolidationtool. If you need a different version, contact K2 Support.