How to Run the SDB DB Integrity Check Tool - Intergraph Smart Reference Data Standard Database - Help

Standard Database for Intergraph Smart Reference Data Upgrade and Migration

Language
English
Product
Intergraph Smart Reference Data Standard Database
Search by Category
Help
Standard Database for Smart Reference Data Version
2020 (12.0)

SDB DB Integrity checks can be run in three ways:

  • From SQLPlus

  • From SDB Utility Tool available in the product

  • Batch schedule on a regular basis

From SQLPLUS

  1. Call the script at the SQL prompt.

  2. Type the database connection string.

  3. Type the password for the database user.

  4. Type the physical path of the database server where the CSV file will be generated within single quotes, for example, ‘D:/oradata/SDB/utl’.

From SDB Utility Tool

  1. Run SDBUtility.exe available in product installation path <SDB Installation Folder>\sdbutilitytool\

  2. Provide the Database, M_SYS and SDB Schema Passwords, SRD Application User in respective fields, and then click Connect.

  3. Select <Project>, <Discipline> and <Language> where scripts need to run on and click OK.

  4. Select a single or multiple script to run using left pane checkbox and click Execute.

  5. Click Export to Excel to export and save the results into a Microsoft Excel workbook.

Batch Schedule Scripts

  1. Include all scripts that need to be scheduled in the BatchInputConfiguration.xml file present in the folder <SDB Installation Folder>\sdbutilitytool\. Use the ScriptsConfiguration.xml file, as a sample.

  2. Add the command shown below in the task scheduler after modifying the database details as required.

    "<SDB Installation Path>\sdbutilitytool\SDBUtility.exe" -X "<SDB Installation Folder>\ \sdbutilitytool\BatInputConfiguration.xml" -O "<Output file path>" -DN "<Database Server>/<Database SID>" -MSP "<M_SYS Password>" -SSP "MANAGER30" -U "SPRDSDB" -P "SDB" -D "PIPING" -L "ENGLISH".

Results will be saved in the Output folder path mentioned in the command.