Generate rails db migrations files from active database

Question

Is there any way to take a running database and generate a migration file from it? If not does anyone have any advice on how to approach that?

Background: Have a new project where a PHP developer jumped into a rails project and starting adding tables and columns though PostGres admin tool.

you mean you want to reverse the added columns from the table. essentially remove the added migrations? — Wally Ali
– Wally Ali, Commented May 16, 2014 at 0:28
Generate a schema of the running database. I think i may have found rake -T db:schema:dump — Austio
– Austio, Commented May 16, 2014 at 0:29
You could just manually add the tables and columns to your schema.rb file. — ChrisBarthol
– ChrisBarthol, Commented May 16, 2014 at 0:30
yeah, try that rake command. usually, you shouldn't touch the schema file. the fields should populate once you run the migration — Wally Ali
– Wally Ali, Commented May 16, 2014 at 0:31
True, stackoverflow.com/questions/11301009/… That answer also suggests db:schema:dump task, which will update your db/schema.rb file to match the structure of your database. — ChrisBarthol
– ChrisBarthol, Commented May 16, 2014 at 0:36

Austio · Accepted Answer · 2014-05-16 00:42:32Z

2

Created a directory called "log" then ran this command

RAILS_ENV=production rake db:schema:dump

answered May 16, 2014 at 0:42

Austio

6,0951 gold badge23 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1