sqlcmd

sqlcmd for Mac and Linux.

Install

npm install -g sqlcmdjs

Usage

sqlcmd -s <server> -u [<domain>\]<username> -p <password> [-o <port>] [-d <database>] [-t <timeout>] [--no-quoted-identifier] [-m param1=foo -m param2=bar ...] <script>

If no script is specified, sqlcmd reads from the standard input.

Example

Run a script:

sqlcmd -s 127.0.0.1 -u sa -p p@ssw0rd "select name, database_id from sys.databases"

Run a script from file:

cat script.sql | sqlcmd -s 127.0.0.1 -u sa -p p@ssw0rd

Run a script and supply template parameter values using the Management Studio format:

sqlcmd -s 127.0.0.1 -u sa -p p@ssw0rd "select name from sys.databases where database_id = <database_id,int,>" -m database_id=1

Run a script and supply template parameter values using the sqlcmd.exe format:

sqlcmd -s 127.0.0.1 -u sa -p p@ssw0rd "select name from sys.databases where database_id = $(database_id)" -m database_id=1

Version History

1.5
- Added port option. (Thanks mbergmann)
- Added an option for setting quoted identifiers to off. (Thanks lanman2000)
1.4
- Added support for Windows domains.
- Added support for sqlcmd.exe style template parameters. (Thanks gunesmes)
1.3
- Added support for template parameters.
1.2
- Added timeout argument.
1.1
- Added support for scripts with GO statements.
1.0
- Initial release.

Author

Soheil Rashidi

Copyright and License

Licensed under the The MIT License (the "License"); you may not use this work except in compliance with the License. You may obtain a copy of the License in the LICENSE file, or at:

http://www.opensource.org/licenses/mit-license.php

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.