DbSync

Have you ever gone to test a specific or develop a feature, except it requires use of data that currently only exists in production?

Instead of going through a very time-consuming database dump and load process, you can use this gem instead.

It works by dumping certain tables you want into some yaml files in db/data. You can then easily load them into your database.

This works a an alternative to ludicast/yaml_db for some use cases.

Installation

Add this line to your application's Gemfile:

gem 'db_sync'

And in config/initializers/db_sync.rb

DbSync.configure do |config|
  config.sync_tables = ["TABLE_NAME"]

  #DEFAULT is db/data/
  config.db_data_folder = "overide/the/folder/path/to/load/the/data" #OPTIONAL
end

Usage

Run this to dump the tables you specified in the initializer to db/data

bundle exec rake db_sync:dump_data

Or run against a specific rails environment

bundle exec rake db_sync:dump_data RAILS_ENV=production

Run this to load the tables back in. WARNING: this overwrites the contents of this existing table.

bundle exec rake db_sync:load_data

Or run this to load the tables back in the order specified in the sync_tables array. WARNING: this overwrites the contents of this existing table.

bundle exec rake db_sync:load_data_order

Contributing

1. Fork it
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Add some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create new Pull Request