How do I migrate data to new version of schema when I update my custom addons?

Question

I am writing custom addons for my company. Over their life these
addons will accumulate data in the tables I have modelled, using the
orm.

During development, when I want to update the schema I have to
uninstall and reinstall the addon. It will drop all the tables and
recreate them.

The question is, when I am deploying a new version of an addon to
product (because it has new features which need new table columns,
etc), how do I safely preserve and migrate the production data to the
new schema

Baiju KS · Accepted Answer

Hi, Darrel

If you want to add a new field to an object, you can do that without losting data, only thing you have to take care is don't uninstall the module. If you you uninstall the module all your data in that object will be lost.

To add an extra field to an object you can simply modify your .py file and .xml file in your module and save that then;-

1. Restart your odoo server

2. Upgrage your module (*Settings*==> select *module*==> click *upgrade*

Now you can see the changes you made wit

Med Said BARA · Answer

The* first thing you have to d*o, is to* backup your database* (just is case .. !), and after that, install or uninstall your new module as usual.

Related Posts	Replies	Views
How to display a field from a different model? module model	1 Mar 15	6200
Module Not Shown In Open ERP module addon	1 Mar 15	5219
How to fix the error to install module "Missing required value for the field 'Model' (model_id) " module app model	1 Feb 25	1888
how to change the type of a field in a model(a table) of the official module (hr) OpenERP module fields model	1 Jul 22	8352
Prefill fields in creation form module fields model	0 Nov 16	6149

This question has been flagged

Enjoying the discussion? Don't just read, join in!