From MySql Schema to Rails migration file

After skimming some forums I found the answer must be quite obvious to Rails developers. Simply make sure that your database.yml file (found in the config/ folder), references to your database. Then execute the following command:

rake db:schema:dump

Now browse to your db folder in which you will find the complete schema of your database within the schema.rb file. Please note that the file will be overwritten so you may want to rename it or split it up into single migration files according to each table.

Please note that this is for development purposes, and not intended to run the generated migration onto a production database.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: