sails-sqlserver-plus

2015-12-21 update

修改了创建数据表时,text与string类型的字段只能创建Varchar(MAX)与NVarchar(Max)的问题

All-in-One Data Management Stack

sails-sqlserver

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