You can run the SDB Utility Tool 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 following
folder: SDB installed location > SDB Utility Tool\tool_usefulscript.
From the SDB Utility Tool
-
Run SDBUtility.exe, available in the product installation path: <SDB Installation Folder>\SDB Utility Tool.
-
Enter the values in the Database, M_SYS Password, SDB Schema Password, and SRD Application User boxes, and then select Connect.
-
Select <Project>, <Discipline>, and <Language> where scripts need to run, and then select OK.
-
Choose a single or multiple scripts to run using the left pane checkbox, and select Execute.
-
Select Export to Excel to export and save the results into a Microsoft Excel workbook.
Batch schedule scripts
-
Include all scripts that need to be scheduled in the BatchInputConfiguration.xml file available in the <SDB Installation Folder>\SDB Utility Tool\ folder. Use the ScriptsConfiguration.xml file as a sample.
-
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".
The results will be saved in the Output folder path mentioned in the command.