Experience using SQL Server and RoR?

I’m building an app for a large enterprise, and the corporate IT folks are suggesting using SQL Server (latest version I assume) instead of MySQL, due to their familiarity with it.

I have limited experience with SQL Server, and even more limited with SQL Server and RoR. One internal app that had somewhat frequent problems. I’ve got years of experience with MySQL, and have seen great results using MySQL and RoR.

I’m not opposed to examining our options, but the problems I’ve had in the past give me pause. And I do like MySQL!

Are there people out their who would share their RoR/SQL Server experiences, good or bad?

Thanks much,
Dan Buettner

I use it. I don't particularly like it, but I've never worked with a
database server for which I had any particular fondness with the
possible exception of PostgreSQL. That said, SQL Server with the ODBC
adapter seems about as stable as anything else. The biggest drawbacks
I've found are that BLOBs are not supported, and likely won't be unless
and until ActiveRecord is rewritten, and that SQL Server is treated as
something of an afterthought in the rails community; a (very) few
plugins only support MySQL and PostgreSQL.

- donald

Limited experience (one small in-house app) and I can't speak for
performance compared to other platforms, but I can vouch for there
being no obvious showstopping problems, which says as much for
ActiveRecord's database-agnostic qualities as anything.

I guess what I'm trying to say, in a nutshell, is that it just
worked. Data got stored and retrieved, which is what should happen.



Using MySQL now and have used SQL Server a ton historically.

Save yourself a lot of energy by trying to convert the corporate
lackeys to MySQL. Probably already using a ton of SQL Server and they
aren't going to change overnight.

ROR works fine with SQL Server and will not take you much to master.
You don't need to know the details of SQL Server, particularly since
most everything that MySQL does, SQL Server does too, and more.
Basically, working from a base of MySQL is easier than understanding
full breadth of SQL Server.

And for a 1,000 good reasons, I recommend using MySQL! Even though
they seem to be getting more interested in making money (it has only
gotten harder to find the free downloads sections), the product is
free and is getting better all of the time.