Data Migration Documentation

Calyx RIM 5.1 Database Migration Scripts

Warning: The CNTNT Audit Migration portion of this migration is optional and can be bypassed. If you decide to migrate the CNTNT audit data, this procedure can be performed at any time before or after the section labeled Installing the Database Upgrade. This allows you to migrate your CNTNT audit data independently of your standard migration to Calyx RIM 5.1. The migration of the CNTNT audit data can be done in full, or based on date ranges.

CNTNT Audit Migration

Perform CNTNT audit migration before running the migration script to migrate from Calyx RIM 5.0 to Calyx RIM 5.1.

There are three options when handling the migration of the CNTNT audit table. You can choose to do one of the following:
  • Drop the table
  • Save the old CNTNT table 
  • Run pre-migration while preserving audit data in a live production system

Drop the Table Entirely

  1. Connect to the database as aud.
  2. Enter the following sql command:
  • drop table aud.cntnt;
  • drop trigger ods.icntnt;
  • drop trigger ods.ucntnt;
  • drop trigger ods.dcntnt;

Save the Old CNTNT Table

  1. Connect to the database as aud.
  2. Enter the following sql command:
  • rename aud.cntnt to aud.dep_cntnt;
  • drop trigger ods.icntnt;
  • drop trigger ods.ucntnt;
  • drop trigger ods.dcntnt;
Note: ODS triggers should be dropped as the ODS schema, and the AUD.cntnt table should be dropped as system or AUD schema.