How to migrate a database from Odoo 9 to Odoo 11?
How to migrate a database from Odoo 9 to Odoo 11?
I would like to migrate data from Odoo 9 community to Odoo 11 community. So I want to write some migration scripts. But, currently I have no idea how I can write a migration script like OpenUpgrade.
How I can use PostreSQL to migrate data from Odoo 9 to Odoo 11.
Can I migrate data by connecting OdooRPC of both versions?
If anyone have idea where to start then please share your ideas.
what about the remaining data lol @ChesuCR
– Hassan ALi
Aug 18 at 0:37
That's no so important haha, you can always check the old data on the old Odoo intance. Migrate data is too costly
– ChesuCR
Aug 18 at 0:44
Anyway if you want to make sql or python scripts to migrate date you will need to know Odoo very well. Firts you will need to upgrade Odoo 9 to the latest commit. I will write for you into an answer...
– ChesuCR
Aug 18 at 0:46
I have idea about odoo development so please share your idea Thanks for your time.
– Hassan ALi
Aug 18 at 0:49
1 Answer
1
You can migrate data in several ways. But you need to know Odoo very well to make such migration.
Raw SQL scripts. If you are an SQL expert this could be a good way to map fields. Take into account that depending on your installed modules Odoo could use up to 500 tables or even more.
ETL tools such as Pentaho Kettle. This is a costly way as well, but it has a GUI.
Openupgrade. It offers migrations script (python) for the main Odoo modules. You would have to write your own migrations scripts for your custom modules and third parties modules (if they do not have them). You would need to follow these steps:
migrations
However, I have never made a complete migration using these methods because they are very costly. So my recommendation is to migrate the database partially, only the essential data (if you want a stable installation).
OpenUpgrade script works perfectly fine for the base modules. For custom modules you can write your own scripts.
– Piotr Cierkosz
Aug 22 at 7:46
It is all about the tables that are changing their names from one version to the other. If you are good with scripting maybe you should join OCA Devs and write some stuff for OpenMigrate? If you are new to the stuff I would recommend to migrate the Odoo with only original modules and then upgrade the custom modules(or download versions for latest Odoo). I made tutorial for this: cier.tech/blog/blog-1/post/…
– Piotr Cierkosz
Aug 22 at 7:52
@PiotrCierkosz When i tried to use OpenUpgrade it replied Could not upgrade to version 10.0 So Only option left for me is RPC. Because i don't have ability to use raw Sql create kind of ETL Tool . Thanks
– Hassan ALi
Aug 27 at 17:03
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
If I were you I would make the migration as easier as possible exporting only the main tables (customers, products, ...) and reimport them on Odoo 11
– ChesuCR
Aug 17 at 23:33