Connect MS SQL Server with Rails

To connect MS SQL Server with Ruby on Rails follow the below steps:

SQL Server (2005 or higher recommended)

Install the adapters and driver

gem install tiny_tds
gem install activerecord-sqlserver-adapter

Ensure the activerecord adapter and db driver gems are defined in your Gemfile

gem ‘tiny_tds’
gem ‘activerecord-sqlserver-adapter’

Permanent link to this article:

Leave a Reply

Your email address will not be published.