found a sweet solution. It's a ruby gem, yaml_db.
1.) Had to create a blank rails project. 2.) Edit database.yml to point to the source db 3.) run rake db:dump 4.) edit database.yml to point to the new db 5.) run rake db:load Voila! done. One of the cool things is that it converts it to a database agnostic format so it's easy to transfer to/from any type of db supported by ActiveRecord. On Jan 23, 2010, at 5:57 PM, Larry C. Lyons wrote: > > use teh ODBC driver for MSSQL. that has worked so far. > > On Sat, Jan 23, 2010 at 3:05 PM, denstar <valliants...@gmail.com> wrote: >> >> I was pretty impressed last time I used it, which was a while ago. >> >> Here's to hoping that it does ODBC as well! :) >> >> :DeN >> >> -- >> When I look upon seamen, men of science and philosophers, man is the >> wisest of all beings; when I look upon priests and prophets nothing is >> as contemptible as man. >> Diogenes >> >> On Sat, Jan 23, 2010 at 12:24 PM, Larry C. Lyons wrote: >>> >>> Denster you beat me to it. I just did a huge conversion recently from >>> M$SQL Server to MySQL using the My SQL Migration toolkit. Fast simple >>> and smooth. Next challenge M$ Access to MySQL. >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:311166 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5