gsqlcmd SQL Request Options

/commandTimeout=<seconds>

Use this option to set the command execution timeout.

/connectionTimeout=<seconds>

Use this option to set the server connection timeout.

/noTransaction

Use this option to disable transaction mode.

Disabling transaction mode is useful when deleting database objects with scripts. If you don't disable it, the server will roll back the transaction if any of the objects to be deleted do not exist.

/noWarnings

Use this option to suppress warning messages from being output to the console.

/parse

Use this option to see how gsqlcmd parses SQL scripts into SQL commands in exec mode.

For example:

gsqlcmd exec db script.sql /parse

/prepare

Use this option to retrieve the final script that will be executed in exec mode.

For example:

gsqlcmd exec db script.sql /prepare /set=param1=value1;param2=value2

You can run the resulting code in exec mode or with another tool.

/trace

Use this option to enable tracing of SQL commands sent to the server.

By default, gsqlcmd writes trace messages to the console. You can specify a log file in gsqlcmd.exe.config located in the gsqlcmd home directory.