Changes
Created page with "The command line applictaion DBTool can be used for managing UBIK.Databases (and partially also for any other database) on a Microsoft SQL Server: Usage: DBTOOL <COMMAND> /<p..."
The command line applictaion DBTool can be used for managing UBIK.Databases (and partially also for any other database) on a Microsoft SQL Server:
Usage:
DBTOOL <COMMAND> /<parameter> <value> etc.
DBTOOL RESTORE (restore a database)
Parameters
/server ... the database server (e.g. /server "mysqlserver")
/user ... (optional) the database user (e.g. /user sa, default: sa)
/pwd ... (optional) the database user's password (e.g. /pwd ***), not required for SPI!
/spi ... (optional) integrated security 'true' = yes, 'false' = no (default false).
/cat ... the new catalog's name (e.g. /cat "XYZ")
/bak ... the backup file path (e.g. /bak "C:\SQL\BAK\XYZ01.bak")
/force ... (optional) force existing databases and/or data/log files to be overwritten! (default: false)
/ndpath ... (optional) the path of the new data file on the server (e.g. /ndpath "C:\SQL\DATA\XYZ02.mdf")
/nlpath ... (optional) the path of the new log file on the server (e.g. /nlpath "C:\SQL\DATA\XYZ02.ldf")
/odname ... (optional) the path of the original data file on the server (e.g. /odname "XYZ01.mdf")
/olname ... (optional) the path of the original log file on the server (e.g. /originallogfilename "XYZ01.mdf")
Examples:
DBTOOL restore /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /bak "C:\MSSQL\Backup\mybackup.bak"
DBTOOL restore /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /bak "C:\MSSQL\Backup\mybackup.bak" /force false /ndpath "C:\SQL\Data\mynewcatalog.mdf" /nlpath "C:\SQL\Data\mynaewcatalog.ldf" /odname myoriginalcatalog /olname myoriginalcatalog_log
DBTOOL UBIKSET (set a UBIK setting value)
Parameters
/server ... the database server (e.g. /server "mysqlserver")
/user ... (optional, default: sa) the database user (e.g. /user sa)
/pwd ... (optional, default: empty) the database user's password (e.g. /pwd ***), not required for SPI!
/spi ... (optional, default: false) integrated security 'true' = yes, 'false' = no.
/cat ... the catalog's name (e.g. /cat "XYZ")
/key ... the system setting key (e.g. /key 0)
/setting ... the system setting key (e.g. /setting 0)
Examples:
DBTOOL UBIKSET /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /key 0 /setting "\\myserver\mydatapath"
DBTOOL RUN (run a sql expression)
Parameters
/server ... the database server (e.g. /server "mysqlserver")
/user ... (optional, default: sa) the database user (e.g. /user sa)
/pwd ... (optional, default: empty) the database user's password (e.g. /pwd ***), not required for SPI!
/spi ... (optional, default: false) integrated security 'true' = yes, 'false' = no.
/cat ... the catalog's name (e.g. /cat "XYZ")
/sql ... the expression (e.g. /sql "SELECT * FROM mytable")
/sep ... (optional, default ";") the expression (e.g. /sep "\t")
Examples:
DBTOOL RUN /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /sql "SELECT * from mytable"
==================
AUGMENSYS-EXAMPLES
==================
//RUN
dbtool RUN /sql "SELECT * FROM dbo.UST_BASECLASS" /cat "UBIK.MANUALTEST02" /server "auglnz2sql" /user "sa" /pwd ****** /verbose false
dbtool RUN /sql "update UST_SYSTEMSETTINGS set PR_VALUE='\\auglnz0file\UBIKData\DBG\UBIK.MANUALTEST07' where PR_KEY=0" /cat "UBIK.MANUALTEST02" /server "auglnz2sql" /user "sa" /pwd ******
//UBIKSET
dbtool UBIKSET /cat "UBIK.MANUALTEST02" /server auglnz2sql /user sa /pwd ******* /key 0 /setting "\\auglnz0file\UBIKData\DBG\UBIK.MANUALTEST08"
//RESTORE
dbtool RESTORE /cat UBIK.MANUALTEST03 /server auglnz2sql /user sa /pwd ******* /bak "C:\MSSQL\Backup\DBG\AUG\UBIK.MANUALTEST\UBIK.MANUALTEST.bak"
dbtool RESTORE /cat UBIK.MANUALTEST04 /server auglnz2sql /user sa /pwd ******* /bak "C:\MSSQL\Backup\DBG\AUG\UBIK.MANUALTEST\UBIK.MANUALTEST.bak" /force true /ndpath "C:\MSSQL\Data\UBIK.MANUALTEST04.mdf" /nlpath "C:\MSSQL\Data\UBIK.MANUALTEST04.ldf" /odname "UBIK.Simulation" /olname "UBIK.Simulation_log"
Usage:
DBTOOL <COMMAND> /<parameter> <value> etc.
DBTOOL RESTORE (restore a database)
Parameters
/server ... the database server (e.g. /server "mysqlserver")
/user ... (optional) the database user (e.g. /user sa, default: sa)
/pwd ... (optional) the database user's password (e.g. /pwd ***), not required for SPI!
/spi ... (optional) integrated security 'true' = yes, 'false' = no (default false).
/cat ... the new catalog's name (e.g. /cat "XYZ")
/bak ... the backup file path (e.g. /bak "C:\SQL\BAK\XYZ01.bak")
/force ... (optional) force existing databases and/or data/log files to be overwritten! (default: false)
/ndpath ... (optional) the path of the new data file on the server (e.g. /ndpath "C:\SQL\DATA\XYZ02.mdf")
/nlpath ... (optional) the path of the new log file on the server (e.g. /nlpath "C:\SQL\DATA\XYZ02.ldf")
/odname ... (optional) the path of the original data file on the server (e.g. /odname "XYZ01.mdf")
/olname ... (optional) the path of the original log file on the server (e.g. /originallogfilename "XYZ01.mdf")
Examples:
DBTOOL restore /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /bak "C:\MSSQL\Backup\mybackup.bak"
DBTOOL restore /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /bak "C:\MSSQL\Backup\mybackup.bak" /force false /ndpath "C:\SQL\Data\mynewcatalog.mdf" /nlpath "C:\SQL\Data\mynaewcatalog.ldf" /odname myoriginalcatalog /olname myoriginalcatalog_log
DBTOOL UBIKSET (set a UBIK setting value)
Parameters
/server ... the database server (e.g. /server "mysqlserver")
/user ... (optional, default: sa) the database user (e.g. /user sa)
/pwd ... (optional, default: empty) the database user's password (e.g. /pwd ***), not required for SPI!
/spi ... (optional, default: false) integrated security 'true' = yes, 'false' = no.
/cat ... the catalog's name (e.g. /cat "XYZ")
/key ... the system setting key (e.g. /key 0)
/setting ... the system setting key (e.g. /setting 0)
Examples:
DBTOOL UBIKSET /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /key 0 /setting "\\myserver\mydatapath"
DBTOOL RUN (run a sql expression)
Parameters
/server ... the database server (e.g. /server "mysqlserver")
/user ... (optional, default: sa) the database user (e.g. /user sa)
/pwd ... (optional, default: empty) the database user's password (e.g. /pwd ***), not required for SPI!
/spi ... (optional, default: false) integrated security 'true' = yes, 'false' = no.
/cat ... the catalog's name (e.g. /cat "XYZ")
/sql ... the expression (e.g. /sql "SELECT * FROM mytable")
/sep ... (optional, default ";") the expression (e.g. /sep "\t")
Examples:
DBTOOL RUN /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /sql "SELECT * from mytable"
==================
AUGMENSYS-EXAMPLES
==================
//RUN
dbtool RUN /sql "SELECT * FROM dbo.UST_BASECLASS" /cat "UBIK.MANUALTEST02" /server "auglnz2sql" /user "sa" /pwd ****** /verbose false
dbtool RUN /sql "update UST_SYSTEMSETTINGS set PR_VALUE='\\auglnz0file\UBIKData\DBG\UBIK.MANUALTEST07' where PR_KEY=0" /cat "UBIK.MANUALTEST02" /server "auglnz2sql" /user "sa" /pwd ******
//UBIKSET
dbtool UBIKSET /cat "UBIK.MANUALTEST02" /server auglnz2sql /user sa /pwd ******* /key 0 /setting "\\auglnz0file\UBIKData\DBG\UBIK.MANUALTEST08"
//RESTORE
dbtool RESTORE /cat UBIK.MANUALTEST03 /server auglnz2sql /user sa /pwd ******* /bak "C:\MSSQL\Backup\DBG\AUG\UBIK.MANUALTEST\UBIK.MANUALTEST.bak"
dbtool RESTORE /cat UBIK.MANUALTEST04 /server auglnz2sql /user sa /pwd ******* /bak "C:\MSSQL\Backup\DBG\AUG\UBIK.MANUALTEST\UBIK.MANUALTEST.bak" /force true /ndpath "C:\MSSQL\Data\UBIK.MANUALTEST04.mdf" /nlpath "C:\MSSQL\Data\UBIK.MANUALTEST04.ldf" /odname "UBIK.Simulation" /olname "UBIK.Simulation_log"
