sqlutil
Use the sqlutil Python script to run SQL scripts to apply database fixes, procedure replacements, and so on. The utility automatically handles schema string replacement and replication. This eliminates the need to manually connect to multiple databases (multi-node setups) via MSSMS and run the same script for each.
Usage
To run the sqlutil program:
Open an administrative command prompt and navigate to the product instance director:
cd C: <Program Files path>\Bravura Security\Bravura Security Fabric\<instance>\
Replace with the actual drive and path of the Bravura Security Fabric instance.
Run the
instance.batfile to configure necessary environment variables:instance.bat
Navigate to the util directory:
cd util
Run the sqlutil.py program:
python sqlutil.py <path>\<SQLscript> [-force]
where the optional -force command forces the SQL script to run if it has been run before.
See also:
You can run a report on script execution history. See Reports .