How can I export database structure from the db into migration file?

Question

Is there a way to export database structure in the database from the rails application? I believe there is a way to export Data from the db using rake.

rake db:migrate will create tables from migration files. Is there a command that does opposite way so that migration files will be generated from the db?

I have previously built a rails application during 3.0.x version.

I have many more migration files than the actual number of tables in the database because I have some migration file which adds and removes or change the column structure of the database.

Obviously, I can manually change each migration file and change it into migration file with 3.1 standard, but I just want to know if there is a way to export data base structure. (Or, deriving from existing schema file)

score 15 · Accepted Answer · answered Sep 18 '11 at 01:48

15

Use command rake db:schema:dump, it will do it for you

Edit: You might be interested in this link: http://www.tutorialspoint.com/ruby-on-rails/rails-and-rake.htm

answered Sep 18 '11 at 01:48

datalost

3,765
1
25
32

That worked :P Thanks!, so its my task to split the file into different migration files? – user482594 Sep 18 '11 at 02:34
2

No. You can "load" the schema directly with rake too. Then you can migrate any changes since you dumped the schema. – Pavling Sep 18 '11 at 06:40
1

Pavling's right. You'd use rake db:schema:load to load it up. – jschorr Sep 18 '11 at 07:19

score -1 · Answer 2 · answered Dec 06 '12 at 17:59

After rake db:schema:dump you can use a gem called schema_to_scaffold to generate a scaffold script. it outputs: rails g scaffold users fname:string lname:string bdate:date email:string encrypted_password:string from your schema.rb our your renamed schema.rb. Check here

How can I export database structure from the db into migration file?

2 Answers2