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
-
Run SDBUtility.exe available in product installation path <SDB Installation Folder>\SDB Utility Tool\
-
Provide the Database, M_SYS and SDB Schema Passwords, SRD Application User in respective fields, and then click Connect.
-
Select <Project>, <Discipline> and <Language> where scripts need to run on and click OK.
-
Select a single or multiple script to run using left pane checkbox and click Execute.
-
Click 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 present in the folder <SDB Installation Folder>\SDB Utility Tool\. 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".
Results will be saved in the Output folder path mentioned in the command.