1. Release Notes
  2. Migration

5 Migration

Both HDR 7.0.2.x (CTB and HCT) schemas and HDR 8.2 (CTB and HCT) schemas are the same. You can directly use HDR 7.0.2.x schemas for HDR 8.2 as is.

If you want to migrate some filtered data from HDR 7.0.2.x CTB schema to HDR 8.2 CTB schema, you can use these migration scripts as a base scripts.

Note:

  • You have to add your filtered condition for all specific SELECT statements in the insert_ctb_temp_tables.sql file while inserting the data into the TEMP tables.
  • HCT schema is a Terminology schema, no filter conditions required to migrate to HDR 8.2. You can use the same HDR 7.0.2.x HCT schema for HDR 8.2.

To migrate HDR 7.0.2.x CTB schema to HDR 8.2 CTB schema, perform the following:

  • Take backup of the existing HDR 7.0.2.x CTB schema using the export schema operation or any other alternative methods.
  • Before migrating CTB schema, ensure that there is enough tablespace available on the database, if required add extra data files to the existing CTB and Index tablespaces.
  • Take the backup of the HDR Delete API PLSQL package (hdr_delete_api.sql) from the CTB schema and reuse the same once the migration is completed successfully.
  • Extract the contents of hdr82_artifacts.zip to a directory on the middle tier.
  • Ensure you have read and write permissions to these directories, subdirectories, and their files.
  • Set HDR_HOME environment variable to a directory where hdr82_artifacts.zip file is extracted.
  • Set JAVA_HOME environment variable to a directory where JDK11 is installed and executable in path.
  • Ensure the ORACLE_HOME environment variable is already set and the ORACLE_HOME/bin directory is configured in the PATH on the machine.
  • Navigate to the $HDR_HOME/database/migration_scripts/HDR7.x_HDR82 directory.
  • Run the migrate_ctb_db_objects.sh script in a specific order to migrate HDR7.0.2.x CTB user database objects to HDR8.2 CTB user database objects. Refer to the Migrate HDR 7.0.2.x CTB Schema to HDR 8.2 CTB Schema section.