Odoo Help


What is the best way to migrate database from Odoo 8 to 9?

Akhil P Sivan
on 4/27/16, 2:21 AM 4,538 views

I have converted my modules but got stuck on DB migration. Can anyone suggest the best methodology. The Openuprade is not stable yet for v8 to v9.

Any help on this would be greatly appreciated.


Sudhir Arya (ERP Harbor Consulting Services)

--Sudhir Arya (ERP Harbor Consulting Services)--
| 6 8 8
Ahmedabad, India
--Sudhir Arya (ERP Harbor Consulting Services)--

• Co-Founder & Co-Owner at ERP Harbor Consulting Services

• ERP Consultant / ERP Customization / TechnoFunctional Expert

• Sound knowledge in Python, Odoo (Open ERP), XML, PostgreSQL

• Domain knowledge of Sale Management, Purchase Management, Warehouse Management, Manufacturing, Multi Company Configuration & Management, HR Management, Medical Management, Construction Management, Education Management, Point of Sale, Third Party Integrations

• Positive attitude and quick Learner

• Good analytical skill, quick bug and issue tracing and find the solution

• Good knowledge and experience in payment gateway integration with Odoo

• Ready to accept new challenges

• Active Memeber On Stackoverflow 




Sudhir Arya
ERP Harbor Consulting Services
Sudhir Arya (ERP Harbor Consulting Services)
On 4/28/16, 12:30 PM

Hi AKhil,

Best way is to go with OpenUpgrade.

Right now for v9, OCA is working on the migration script and will be ready soon for the migration.

Any other solutions Sudhir?

Akhil P Sivan
on 4/29/16, 3:37 AM

Can i migrate a database of odoo 9 to odoo 11 directly ? or i should need to do 9 to 10 , then 10 to 11 ? [using OCA migration script]

Aslam Up
on 11/13/17, 5:11 AM

Hello Akhil,

If you are covered by the Odoo Enterprise contract, you will be automatically provided the upgrade/migration service. This is the official and best way to upgrade your database to  newer version.

You pay extra only if you wish Odoo to migrate custom modules too. But since you have already migrated custom modules yourself, you just need to add them in your addons-path allow them to load with your already upgraded database.

Detailed steps of the official Odoo Upgrade process is explained at https://upgrade.odoo.com/database/upload , where you can also upload your database.

You might also find this post (https://www.odoo.com/forum/help-1/question/how-to-upgrade-to-v7-with-opw-contract-2580) helpful which explains a migration for v7.0 (the overall process is the same for upgrades to v8.0, v9.0, etc.)

Mohit Chandra (Webkul)
On 4/28/16, 11:14 AM

Hi Akhil, 

I have also gone many times this situation when i need to migrate data from odoo version 8 to odoo version 9, in such case the way i preferred is - 

1) Make that module compatible to the later version of odoo.

2) For data migration, do manually(LOL) or use some Posgresql commands(Not preferred as it not following odoo ORM methods), The best way among all is -- Make 1 script based on xmlrpc which interact with your previous odoo database, and populate same data to the later one.

For me, it is working perfectly till now.

Feel free to share any other way, if any :D 

But that worked for importing the product or partner images also? Can you give me an example for the xmlrpc script?

Akhil P Sivan
on 4/29/16, 3:19 AM

Yes, it worked for importing product as well as partner images too. Check this link https://www.odoo.com/documentation/8.0/api_integration.html Odoo official documentation is great, try it out and let me know if it worked or not.

Mohit Chandra (Webkul)
on 5/2/16, 1:51 AM
On 4/27/16, 3:15 AM

Hello Akhil

First check functionality odoo 8 and also check any changes  depends module in odoo9 

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

2 follower(s)


Asked: 4/27/16, 2:21 AM
Seen: 4538 times
Last updated: 7/17/17, 6:33 PM