I have database scripts which create database with more than 100 tables and lot of data. It is a tedious task for me to create Rails Migration classes for whole database. But i see Rails Migration as a good option in long term database change management. Please suggest some way to generate Rails Migrate classes automatically from MYSQL database instance.
This can be done in three simple steps:
- write config/database.yml to reference your database.
Run "rake db:schema:dump" to generate db/schema.rb. Here's the documentation:
$ rake -T db:schema:dump ... rake db:schema:dump # Create a db/schema.rb file that can be portably used against any DB supported by AR
Convert schema.rb into db/migrate/XXXXXX_create_migration.rb:
class CreateMigration < ActiveRecord::Migration def self.up # insert schema.rb here end def self.down # drop all the tables if you really need # to support migration back to version 0 end end