MS SQL Server Waterline Adapter

Official Microsoft SQL Server adapter for Waterline. Tested on SQL Server 2012 and 2014, but should support any SQL Server 2005 and newer.

1. Install

$ npm install waterline-mssql --save

2. Configure

config/models.js

{
  connection: 'sqlserver'
}

config/connections.js

{
  sqlserver: {
    adapter: 'waterline-mssql',
    user: 'cnect',
    password: 'pass',
    host: 'abc123.database.windows.net' // azure database
    database: 'mydb',
    options: {
      encrypt: true   // use this for Azure databases
    }
  }
}

License

MIT

Maintained By