gem install rails_db_dump_restore

rake tasks

# Dump database to tmp/database.dump
rake db:dump
# development database dumped to tmp/database.dump

# Replace database with contents of tmp/database.dump
rake db:restore
# development database replaced with contents of tmp/database.dump

capistrano tasks

# Replace local database with a remote one
cap production db:pull
# Dumps production database to remote tmp/database.dump
# Downloads the dumpfile to local tmp/database.dump
# Replaces local database with contents of tmp/database.dump

Add require 'capistrano/rails_db_dump_restore' to your Capfile

Quirks

Only works with postgresql and mysql2 database adapters as of now. You should add support for others.

Dummy

We have a dummy app in another repo that is used for testing out this gem Make sure to clone it beside the gem repo

cd ..
git clone git@github.com:standout/rails_db_dump_restore_dummy
cd rails_db_dump_restore_dummy
bundle
rake dummy