DBTOOL RUN /server myservername /user myusername /pwd mypassword /spi false /cat mynewcatalog /sql "SELECT * from mytable"
==================AUGMENSYS-EXAMPLES===============Examples===
//RUNdbtool RUN /sql "SELECT * FROM dbo.UST_BASECLASS" /cat "UBIK.MANUALTEST02TEST" /server "auglnz2sqlsqlserver" /user "sa" /pwd ****** /verbose falsedbtool RUN /sql "update UST_SYSTEMSETTINGS set PR_VALUE='\\auglnz0filefileserver\UBIKData\DBG\UBIK.MANUALTEST07TEST.COPY' where PR_KEY=0" /cat "UBIK.MANUALTEST02TEST.COPY" /server "auglnz2sqlsqlserver" /user "samyuser" /pwd ******"mypwd"
//UBIKSETdbtool UBIKSET /cat "UBIK.MANUALTEST02TEST:COPY" /server auglnz2sql sqlserver /user sa myuser /pwd ******* mypwd /key 0 /setting "\\auglnz0filefileserver\UBIKData\DBG\UBIK.MANUALTEST08TEST.COPY"
//RESTOREdbtool RESTORE /cat UBIK.MANUALTEST03 /server auglnz2sql /user sa myuser /pwd ******* mypwd /bak "C:\MSSQL\Backup\DBG\AUG\UBIK.MANUALTEST\UBIK.MANUALTESTTEST.bak"dbtool RESTORE /cat UBIK.MANUALTEST04 /server auglnz2sql /user sa /pwd ******* mypwd /bak "C:\MSSQL\Backup\DBG\AUG\UBIK.MANUALTEST\UBIK.MANUALTESTTEST.bak" /force true /ndpath "C:\MSSQL\Data\UBIK.MANUALTEST04TEST.COPY.mdf" /nlpath "C:\MSSQL\Data\UBIK.MANUALTEST04TEST.COPY.ldf" /odname "UBIK.SimulationTEST" /olname "UBIK.Simulation_logTEST_log"
