@script-box/mssql-tool.cli v0.0.1

@script-box/mssql-tool.cli

A simple tool for Microsoft Sql Server

Install

npm install @script-box/mssql-tool.cli --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 --server MY_SERVER_NAME --username admin --password p@$$w0rd

Run npx mssql help create-database for more options.

create-login

npx mssql create-login new_user_name new_password --server MY_SERVER_NAME --database MyDatabase --username windows_user --password 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 --server MY_SERVER_NAME --database MyDatabase --username windows_user --password p@$$w0rd

Run npx mssql help run-migrations for more options.

drop-database

npx mssql drop-database MyDatabase --server MY_SERVER_NAME --username admin --password p@$$w0rd

Run npx mssql help drop-database for more options.