@ehansen486 I've done it before. Many gigs of data too. Ruby to SQL is never going to be as fast as a pure SQL statement/proc of some sort. Only way you can re-use insert statments for raw TinyTDS is how the adapter does with MS' sp_executesql. You will need to write up your params manually tho. Not sure it is worth it. How much data are you doing? ETL of any type?
@SoNerds It should be very straight forward. Basically ensuring the right username and password in ActiveRecord's database.yml is the only thing you need to do. Using Rails with SQL Server is like any other DB now in Rails now. There is no special magic past installing the gems.
For those getting started, not legacy DBs or apps, I wrote this article the other day.
Can be n-number of databases. Creds can be read/write. What ever you want. ActiveRecord allows you to use establish_connection for a base model to another DB... v5.1 even brought above new YAML format to support this too.