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.
This gem is for exporting and importing data from different databases.
Recommended use is for syncing certain tables from production into development for testing.
It exports specified tables into yaml stored in db/data.
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"]
end
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
- Fork it
- Create your feature branch (
git checkout -b my-new-feature
) - Commit your changes (
git commit -am 'Add some feature'
) - Push to the branch (
git push origin my-new-feature
) - Create new Pull Request