Q:

Ruby on Rails with sql server

There is a chance I will have to make a project using RoR with a SQL Server 2008 r2 database. Is there any complication with using sql server as opposed to mysql when it comes to developing with RoR?

A:

The only difference between the mysql adapter and the SQLServer adapter is that the later depends on the freetds gem.  And when you first setup up your connection,  you may have to deal with some simple utilities that come with freetds to verify or debug the connection.  Once you are connecting,  there is no difference in the way you deal with the database,  no where in your RoR code is ANYTHING specific to SQLServer vs. mysql, it's all handled by the SQLServer adapter and freetds.

