sails-sqlserver-sailsv1

All-in-One Data Management Stack

$3

[![NPM version][npm-image]][npm-url]
[![Build status][ci-image]][ci-url]
[![Dependency Status][daviddm-image]][daviddm-url]

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.

$3

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

    }

  }

}

License

MIT

[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

All-in-One Data Management Stack

$3

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

    }

  }

}