Rails db migrate generate migrate file

Question

When working on a project, I keep track of all the changes I make to a database in a notepad file. Then, later, I manually write all the changes in rails' db migration file.

But it should be possible to compare the schema of a backup of my database, with the new version of my database, and automatically detect the differences. And generate the rails db migration file automatically.

Is there a tool that can compare two database schema's and automatically generate rails' db migration files?

Don't change the schema file manually.

Bharat soni
– Bharat soni

2016-04-18 09:29:14 +00:00
Commented Apr 18, 2016 at 9:29 — Bharat soni
– Bharat soni, Commented Apr 18, 2016 at 9:29

Anthony E · Accepted Answer · 2016-04-18 09:29:57Z

2

As far as I'm aware, there's no tool that will do it automatically, however, you can get most of the way there just using rake db:schema:dump with source control.

Create a new Rails project and do the following:

Update database.yml to connect to your first database.
Use rake db:schema:dump to populate schema.rb and commit schema.rb to git.
Update database.yml to connect to your second database and again run rake db:schema:dump
Use git diff on schema.rb to compare the changes. This can easily be mapped to a migration.

The benefit of using source control is that you can then test the migration by comparing schema.rb after the migration runs to the schema dump of the second database.

answered Apr 18, 2016 at 9:29

Anthony E

11.3k2 gold badges28 silver badges46 bronze badges

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

Collectives™ on Stack Overflow

Rails db migrate generate migrate file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related