Topic: Migrate data From SQL to MySql


i have some tables + associations between tables in SQL database
now as i have shifted my code from .NET to Rubyonrails
so i want to migrate the db structure and records from SQL to  mysql database
can anyone can tell me
how can i do this using rubyonrails scripts/migration command

Re: Migrate data From SQL to MySql

I would setup rails to work with my SQL database, use 'rake extract_fixtures' to extract the data into YML files, reconfig rails to work with mysql, and 'rake db:bootstrap'.  For details on extract_fixtures and bootstrap, use search and read the post in Tutorials that I posted. - Brewery and Brewpub management powered by RoR