How to Run the SDB Utility Tool - 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

SDB Utility can be run in two ways:

  • From the SDB Utility Tool available in the product

  • Batch schedule on a regular basis

To run the scripts manually, utilize the useful scripts available in the SDB installed location > SDB Utility Tool\tool_usefulscript folder.

From SDB Utility Tool

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

  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>\SDB Utility Tool\. 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>\SDB Utility Tool\SDBUtility.exe" -X "<SDB Installation Folder>\ \SDB Utility Tool\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.