Official Microsoft SQL Server Adapter for sails.js, by
JavaScript
Clone or download
#60 Compare This branch is 82 commits ahead, 3 commits behind astropunk:master.
tjwebb Merge pull request #21 from RubiconInternational/master
fix issue with string literal values not prepended with 'N' before th…
Latest commit f764cfb Jul 31, 2015

README.md

All-in-One Data Management Stack

sails-sqlserver

NPM version Build status Dependency Status

Official Microsoft SQL Server adapter for sails.js. Tested on SQL Server 2012 and 2014, but should support any SQL Server 2005 and newer. CI tests are run against SQL Server Express. Published by c*nect.

1. Install

$ npm install sails-sqlserver --save

2. Configure

config/models.js

{
  connection: 'sqlserver'
}

config/connections.js

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

License

MIT