Where there is a will there is a way. There is a common misconception that Rails cannot connect to two databases, and this is not entirly true. You can connect rails to multiple databases(you can't connect models to multiple database, well at least not easily). So in this case, you'd connect rails to your main DB(which I presume you already have) and then also connect it to the legacy database but you just have a User model that uses that second db connection. So anytime you do a User.find(:all) or maybe in your case User.find_by_sql(insert sql statement here) you will be interacting with your old db.
Does that make any sense at all?
Cheers, Cam
Gab Gabi wrote: