3

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?

2 Answers 2

6

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.

Sign up to request clarification or add additional context in comments.

Comments

0

Shouldn't be too much of an issue; see this screencast on Rails 3, Ruby 1.9.2, Windows 2008, and SQL Server 2008 by Xavier Shay.

If you do run into issues while working on this project, StackOverflow is always there to rescue you ;-)

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.