This question has been flagged
3 Replies
4049 Views

I am using odoo-7 since 4 monts on wards. I have sales, purchases, and bank transactions which are there in draft, confirmed, validated statments. I have developed some custom modules that fits to my customer requirements. I want to move this data to odoo-8. How can i proceed for this?. Exporting and importing data easy. But we have to make clone of the odoo-7 to odoo-8, does it possible with this approach is my question?. I hope upgrading from odoo-7 to odoo-8 done by odoo organization. Does this upgrade process allows our coustomized modules?.

Avatar
Discard
Best Answer

except asking odoo to do migration for you... 
you can take a look here : 
https://github.com/OpenUpgrade/OpenUpgrade

hope it helps :)

Avatar
Discard
Best Answer

I have done it by working with SQL directly.  It only takes a few minutes to create a fresh clean database with all the same modules (if they exist for v8).  It took me a couple of days to write a very large SQL script.  Then it took me another day to test and fix the remaining errors.

It went like this:

  • Install all the modules on v8
  • Import v7 database to a different schema (call it v7)
  • Compare a list of tables between versions
  • Compare a list of columns between tables
  • Insert into new schema by selecting from old schema
  • In most cases, I copied the id and then updated the sequence
  • Most of my records could be uniquely identified by the name field, so I used that for mapping where necessary

The mail and messaging stuff was the hardest part to get right.

Avatar
Discard

Matt you are a techno geek. Me likies (bad English intended). You should consider using your skills to help our the OpenUpgrade project. https://github.com/OpenUpgrade/OpenUpgrade

Best Answer

This people developed an ETL tool over Odoo, It seems very interesting and easy to use:

http://www.ingenieriaadhoc.com/blog/our-news-1/post/beta-version-of-mini-etl-odoo-project-migration-of-6-1-db-to-8-0-32

Avatar
Discard