I have a database that I used for the modification of some modules in a development environment, but contains fictitious test data, I want to know if there is any way to reset the database and have it ready to put the system in a production environment,
thanks in advanced.
In short - you can't - without spending a lot of time learning the data model, ensuring you delete from related tables, resetting sequences, etc. Even then you could miss something and put your database into an inconsistent state.
Modules are portable and can be installed on a fresh, empty database. Other customizations you should export and import into a fresh, empty database.
This is really the same question as:
As Ray pointed out, there's no easy way to 'clean' a database. It's possible to delete/reverse some transactions, but that may have subtle effects that do not show themselves until later down the line.
The best advice is to set up a 'baseline' database, which contains configuration/settings, but no transaction data. This would ensure that you always have a 'clean' state to revert to should something go wrong with your live database. I'd also suggest configuring daily backups, as this saves a LOT of headache should something go wrong.
Backups module: https://apps.openerp.com/apps/modules/8.0/auto_backup/
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 12/7/15, 2:35 PM|
|Seen: 494 times|
|Last updated: 12/8/15, 3:23 AM|