sqlcmd for Mac and Linux.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore Initial commit Jul 28, 2015
LICENSE Initial commit Jul 28, 2015
README.md Updated version to 1.5. Apr 13, 2017
package.json Updated version to 1.5. Apr 13, 2017
sqlcmd.js Added port option. Apr 13, 2017

README.md

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

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.