Step 2: Run SDB 12.3 Upgrade script - Intergraph Smart Reference Data Standard Database - Version 12.3 - 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.3

To upgrade the target database version to SDB 12.3, you need to run upgrade.sql script on the SDB 12.1/12.2 database.

You should upgrade the database version to Smart Reference Data 10.2 before proceeding with the migration.

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

How to run upgrade.sql script

  1. Open Command Prompt as an Administrator.

  2. Enter 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.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.3\logs" and "C:\Program Files\Standard Database for Intergraph Smart Reference Data\SDB 12.3\cip_backup".

  3. Connect to the database using SQLPlus. Sign in with SYS user and include as sysdba after the username.

    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 enter the complete path of sqlplus.exe or Oracle home directory should be added in environment variables paths.

    • In case of multitenant architecture (CDB/PDB), ensure that you are connected to PDB and not to CDB.

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

    SQL>@ upgrade.sql

  5. 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_general.

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