Simple example applications connecting to an MS SQL DB hosted in Azure.

Assumes you have an available MS SQL Server instance with the AdventureWorksLT 2014 sample DB.

# Set environmental variables for DB connection
export MSSQL_USERNAME='USERNAME'
export MSSQL_PASSWORD='PASSWORD'
export MSSQL_SERVER='SERVER.database.windows.net'
export MSSQL_DATABASE='AdventureWorks'

# install dependencies
npm install

node tedious.js
node mssql.js
node knex.js
node sequelize.js

Using sequelize-auto I generated models for the existing schema:

npm install -g tedious
npm install -g sequelize-auto

sequelize-auto -o "./models" -d DATABASE -h SERVER -u USERNAME -p 1433 -x PASSWORD -e mssql -c sequelize-auto-config.json

Had to manually correct UUIDV4 to UUID in models and removed some models generated for system db objects and views.

• Tedious is just a Javascript driver for TDS, which is nice as it does not require you to install ODBC
• MSSQL is a wrapper around Tedious, adding nicer query handling and promises
• Knex is a query builder which uses MSSQL as the DB client to build complex queries and operations
• Sequelize is an opinionated ORM library that takes a Code-First approach, with model objects defining the schema used in the DB

• Tedious
• MSSQL
• Knex
• Sequelize