Skip to content

sean-m-oleary/sqlcmd

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

sqlcmd

sqlcmd for Mac and Linux.

Install

npm install -g sqlcmdjs

Usage

sqlcmd -s <server> -u [<domain>\]<username> -p <password> [-d <database>] [-t <timeout>] [-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.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

Copyright 2015 Soheil Rashidi

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.

About

sqlcmd for Mac and Linux.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • JavaScript 100.0%