I have seen OpenUpgrade, which seems to be a utility to migrate databases between major versions of Odoo. Is there any way to update a database schema when something changes between nightly builds?
Here's some background: see this post, in which I described how creating a new database after updating Odoo allowed me to install my module which overrides the purchase order report body template. The problem I have now is that we have another database that we need to update, but the Odoo backup/restore mechanism doesn't allow for the database schema to be upgraded. When you restore the backup, you're still stuck with the database as it was at the time of backup. Something changed in Odoo, but you can only use the changes if you create a brand new database. Any hints?
This is what finally worked for me: (run from the folder containing the new version of Odoo)
./odoo.py --addons='my_addons_dir' -u all -d MyDBName
The key part was adding the database flag/name along with the "-u all". Simply using "-u all" without the database name didn't do it. After running the above command, Odoo was able to find the pertinent External ID and the module installed in the pre-existing database without problems.
V8 is a stable version, so schema is not updated since the release.
It will be the same thing with saas version. Once the freeze done, we don't upgrade the schema.
The only db schema which can change at any time is the master branch.
Sometimes, you can need to update a module to have some fix in view (xml) but never schema SQL or other things which change the API !
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: 1/27/15, 4:38 PM|
|Seen: 994 times|
|Last updated: 3/16/15, 8:10 AM|