This question has been flagged
3 Replies
7670 Views

Hello everyone,

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.

 

Avatar
Discard
Best Answer

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:

https://www.odoo.com/forum/help-1/question/how-to-remove-demo-data-from-an-already-live-and-running-application-22683

Avatar
Discard

Hello Mr. Ray Can you please tell me how can i use a countdown timer in my custom module.I am developing an examination module for online tes..so kindly guide me on the same..I ll be thankful to you for your kind act.

Best Answer

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/

Avatar
Discard