Migrating K2B Audit data from version 6.x to 7.0

NOTE: If your are migrating from previous versions of K2B Audit you should follow the steps described in Migrating K2B Audit data to version 6.0 first.

K2B Audit 7.0 has slightly changed the 6.x database structure to add multi-tenant support. A database reorganization is required that should be deployed to and run on all application installations.

This documents describes a deployment alternative that easies development work.

Migrating data to K2B Audit 7.0 structure require a few SQL commands to be executed. These commands are grouped into SQL Scripts that must be run using the utility provided by the DBMS.

SQL Scripts location

SQL Scripts to migrate data to K2B Audit 7.0 database structure are located in subdirectory 'Packages\K2BTools\Audit\MigrationScripts\ToVersion70'. The subdirectory is located under the GeneXus installation directory.

The following table shows the SQL Script name for each DBMS.

DBMS Script name
Oracle Oracle.sql
PostgreSQL PostgreSQL.sql
SQL Server SQL Server.sql
iSeries DB2400.sql