Step 2: Pre Migration Scripts to run - Intergraph Smart Reference Data Standard Database - Version 12.1 - Installation & Upgrade - Hexagon PPM

Standard Database for Intergraph Smart Reference Data Upgrade and Migration

Language
English
Product
Intergraph Smart Reference Data Standard Database
Search by Category
Installation & Upgrade
Standard Database for Smart Reference Data Version
12.1

To upgrade the target database version to SDB 12.1, users need to run upgrade.sql script on the SDB 2020 database which is to be migrated.

User should upgrade their database version to Smart Reference Data 10.0 before proceeding with the migraton.

This upgrade script will install all the additional SDB objects required for SDB 12.1 upgrade.

How to run scripts

  1. Open command prompt as an Administrator.

  2. Go to the SDB Product installation location in the command prompt to run upgrade.sql script.

    For example, cmd>cd "C:\Program Files\Standard Database for Intergraph Smart Reference Data\SDB 12.1".

  3. Make sure you have WRITE permissions on the "logs" and "cip_backup" folders.

    For example: "C:\Program Files\Standard Database for Intergraph Smart Reference Data\SDB 12.1\logs" and "C:\Program Files\Standard Database for Intergraph Smart Reference Data\SDB 12.1\cip_backup".

  4. Connect to the database using SQLPlus. Login with sys user as sysdba.

    For example, cmd>"<Oracle_Home>\BIN\sqlplus.exe" sys/<Password>@<SID> as sysdba;

    In case SQLPlus is not accessible from the command prompt, then you need to give the complete path of sqlplus.exe or Oracle home directory needs to be added in environment variables paths.

  5. Execute the script, upgrade.sql. Provide all inputs prompted by script. (Default password for SDB user is MANAGER30.)

    SQL>@ upgrade.sql

  6. Log files will be generated in the ‘logs’ folder present in the SDB installation location.

    The default log file path is <SDB Installation Location>\logs\.

  • Few of the pre migration scripts may fail to run if the target database has invalid records.

  • Backups of target database packages are stored in the <SDB installation folder>\ cip_backup folder. If any customization has been done in these packages before, you must merge the changes after completing the migration.

  • The backup package in the cip_backup folder is overwritten each time the SDB migration is run. A copy of this folder must be created before running the SDB migration again.

  • Copy the S50RSDB.rdf file from <SDB Install Folder>\Reports to the application server (<Smart Materials Installation Folder>\rep\) to extract spec reports from the S.50.R.SDB.03 SDB Spec Report screen.

  • After migration, it is recommended to run the post import script (post_import.sql) specific to the Smart Reference Data version. The post_import.sql file can be found in <Smart Materials Installation folder>\samples\post_import\import_10000.

  • Any modifications made to the custom packages on the target database need to be handled after upgrade process.