README
mssql-tool
A simple tool for Microsoft Sql Server
Install
npm install @zero-version/mssql-tool --save-dev
Usage
Under the hood, mssql-tool uses mssql with the default tedious driver. For commands that connect to a database, the arguments map to the options in these packages.
create-database
npx mssql create-database MyDatabase -s MY_SERVER_NAME -u admin -pw p@$w0rd
Run npx mssql help create-database
for more options.
create-login
npx mssql create-login new_user_name new_password -s MY_SERVER_NAME -d MyDatabase -u windows_user -pw p@$w0rd
Run npx mssql help create-login
for more options.
create-migration
npx mssql create-migration
Run npx mssql help create-migration
for more options.
run-migrations
npx mssql run-migrations /path/to/migrations -s MY_SERVER_NAME -d MyDatabase -u windows_user -pw p@$w0rd
Run npx mssql help run-migrations
for more options.
drop-database
npx mssql drop-database MyDatabase -s MY_SERVER_NAME -u admin -pw p@$w0rd
Run npx mssql help drop-database
for more options.