exec-mssql
Execute your ms.sql files which contain multiple sql statements.
GO
deliminators in files are replaced at runtime by ;
Usage
As a CLI tool
-
Make sure you have
exec-mssql
installed globallynpm install -g exec-mssql -
Configure your db access for the first time. Usage:
exec-mssql [-e] -c "server" "database" "user" "password"
.exec_mssql -c "localhost" "database" "root" "root"
-
Execute a bunch of sql statements
exec_mssql "use db_cam; delete from admin;" -
Execute a
.sql
fileexec_mssql -f ./db.sql
As a Node dependency
-
Make sure you have
exec-mssql
installed locallynpm install exec-mssql -
Require and use
var exec_mssql =dbConfig =host: 'localhost'database: 'myDatabase'user: 'root'password: 'root'options:encrypt: falsesql = 'use db_cam;'sqlFile = __dirname + '/db.sql';exec_mssql