How to Remove Old Database Migrations in Ruby on Rails

Recently we’ve overtaken a big project for maintenance and further development. It’s a Rails application with many models, controllers and of course lots of database migrations. There were about one hundred files in db/migrate directory. The question is: how can we setup development environment with current database structure? Running rake db:migrate would just be a suicide. It won’t simply work, because these migrations were written long time ago and the current code and models implementation don’t fit them. Instead let’s load schema.rb file using this command:

1rake db:schema:load

It will create all needed tables for models and also a special table schema_migrations to track migrations. Selecting all rows you will see something like this:

1select * from schema_migrations order by version;
2    version
3----------------
4 20120327182713
5 20120415183320
6 20130815194056
7 ...
8 20140418200422
9 20140427072247
10 20140427083434
11(94 rows)

So, how can we use this special table to get rid of smelly migration files?

The solution

We can just create new migration and copy all add/create statements from schema.rb

1rails g migration CreateStructure

The migration can look like this:

1class CreateStructure < ActiveRecord::Migration
2  def change
3    create_table "users", force: true do |t|
4      t.string   "name"
5      t.datetime "created_at"
6      t.datetime "updated_at"
7      t.text     "track_ids"
8      t.integer  "team_id"
9    end
10
11    ...
12
13    create_table "teams", force: true do |t|
14      t.string   "name"
15      t.string   "slug"
16      t.datetime "created_at"
17      t.datetime "updated_at"
18    end
19  end
20end

Then we need to change it a little bit, because we don’t won’t to lose any data while deploying new migration to staging or/and production environment. Just remove force: true option to make sure we will never lose any data by recreating tables. So let’s try to run this new migration:

1rake db:migrate
2
3== 20140705105820 CreateStructure: migrating ==================================
4-- create_table("users")
5
6rake aborted!
7
8StandardError: An error has occurred, this and all later migrations canceled:
9
10PG::DuplicateTable: ERROR:  relation "users" already exists

Yes, well, it didn’t work, because we’ve already loaded schema.rb and all our tables are already there. So what can we do? We can use the latest version of migration from our schema_migrations and rename the new one:

1mv db/migrate/20140705105820_create_structure.rb db/migrate/20140427083434_create_structure.rb

Finally, we can remove all migrations excluding the current one:

1cd db/migrate/ && ls | grep -v '20140427083434_create_structure' | xargs rm

Now, if we run db:migrate we won’t see any results or errors because we’ve have already migrated the database. However, if we have to setup a new environment we can run all (one) our migrations without any problems.

What’s left?

There is a small problem with this solution. If you have migrations which are modifying data like adding admin account or so, you need to find them manually and copy the code to our structure migration or add a new migration. The data is not included in schema.rb