Hi,
I'm looking for a gem to copy data between the production and the developing environment, the main reason is to offer "the real data" to the final users (I know ideally we should have pre-production), the process should be something like:
1. Select the environment origin and destiny from database.yml
2. Select table to copy. Ex: "user%,products%,companyies"
3. Select "all" or "updated from"... so that I don't have to copy all the table
4. Select overwrite or keep for date in destiny with update from higher than selected.
5. Select force or "rake db:rollback" to the production environment
6. Copy with active record so that it works between different databases.
7. In case of "rake db:rollback" auto "rake db:migrate"
I was thinking to make the gem by myself, but I was wondering that probably somebody did something similar. Does anybody know?
Greetings
I'm looking for a gem to copy data between the production and the developing environment, the main reason is to offer "the real data" to the final users (I know ideally we should have pre-production), the process should be something like:
1. Select the environment origin and destiny from database.yml
2. Select table to copy. Ex: "user%,products%,companyies"
3. Select "all" or "updated from"... so that I don't have to copy all the table
4. Select overwrite or keep for date in destiny with update from higher than selected.
5. Select force or "rake db:rollback" to the production environment
6. Copy with active record so that it works between different databases.
7. In case of "rake db:rollback" auto "rake db:migrate"
I was thinking to make the gem by myself, but I was wondering that probably somebody did something similar. Does anybody know?
Dont' think it will do all of what you want, but look into GitHub - ricardochimal/taps: simple database import/export app
3/4 are going to be the problematic ones as they tend to be more "business related"... Also, what about...
3a. Handle data that's been deleted...
-philip