Odoo Help


How to reset database for production environment (Odoo v8/v9)

Adnier Rosello
on 12/7/15, 2:35 PM 1,473 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.



Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 12/7/15, 7:18 PM

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:


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.

Shivam Mahajan
on 12/8/15, 2:17 AM
Ryan Cole
On 12/8/15, 3:23 AM

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/

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/7/15, 2:35 PM
Seen: 1473 times
Last updated: 12/8/15, 3:23 AM