sqlcmd for Mac and Linux.
npm install -g sqlcmdjs
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.
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
- 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.
Soheil Rashidi
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.