[Ruby] MS SQL Server advice?

[Bryan Liles]

On Oct 2, 2007, at 12:40 PM, ben wiseley wrote:

> I'm working with a startup that would like to integrate with  
> OpenTravel CRM
> ( http://www.opentravelcrm.com/ ) which is .Net on MS SQL Server.   
> While
> writing my own CRM isn't that scary - integrating with legacy  
> travel systems
> is.
>
> Anyone have production level experience with Rails on SQL Server?   
> Is it a
> total nightmare or not-so-bad?  I've heard it works, but does it  
> scale up?
> We'd run their CRM and SQL Server on a windows box and Rails on a  
> Linux box
> that connected to the SQL Server box (or possible do virtualization  
> all on
> Linux).
>
>

This is totally possible.  I've run a linux based rails app that used  
sql server for its backend.  The only problems are that the sql- 
server-adapter is made for sql server 2000, and you won't be able to  
take advantage of the improvements in 2005.  Also the maintainer  
situation for the adapter is in flux.  Now that it isn't part of core  
rails anymore, I'm not sure who is going to be maintaining it.

The install for it isn't too bad, you just have to configure freetds,  
unixODBC, ruby-dbi, and one other package that I don't remember off  
the top of my head.

Good luck.