activerecord-jdbcmssql-adapter

* https://github.com/jruby/activerecord-jdbc-adapter/

DESCRIPTION:

This is an ActiveRecord driver for MS-SQL using JDBC running under JRuby.

SQL Azure

To use this driver with SQL Azure you will need to follow these steps:

  1. Add the official Microsoft SQL Server JDBC driver to your classpath. The quick way is to include rubygems.org/gems/jdbc-mssql-azure in your gemfile. If you want to include the jar manually it can be downloaded here www.microsoft.com/download/en/details.aspx?displaylang=en&id=19847

  2. Configure your database.yml as follows:

    production:
      adapter: jdbcmssql
      driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
      url: 'jdbc:sqlserver://servername.database.windows.net;databaseName=databasename'
      username: [email protected]
      password: bar