@zero-version/mssql-tool

A simple tool for Microsoft Sql Server

Usage no npm install needed!

<script type="module">
  import zeroVersionMssqlTool from 'https://cdn.skypack.dev/@zero-version/mssql-tool';
</script>

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.