Official SQL Server Adapter for Sails / Waterline
npm install news-sails-sqlserver
All-in-One Data Management StackOfficial 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.
Note: I'm update from npm sails-sqlserver
sh
$ npm install sails-sqlserver --save
`$3
####
config/models.js
`js
{
connection: 'sqlserver'
}
`####
config/connections.js
`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
}
}
}
``[npm-image]: https://img.shields.io/npm/v/sails-sqlserver.svg?style=flat-square
[npm-url]: https://npmjs.org/package/sails-sqlserver
[sails-logo]: http://cdn.tjw.io/images/sails-logo.png
[sails-url]: https://sailsjs.org
[ci-image]: https://img.shields.io/circleci/project/cnect/sails-sqlserver/master.svg?style=flat-square
[ci-url]: https://circleci.com/gh/cnect/sails-sqlserver
[daviddm-image]: http://img.shields.io/david/cnect/sails-sqlserver.svg?style=flat-square
[daviddm-url]: https://david-dm.org/cnect/sails-sqlserver