As OpenERP6 is not long from being released, yet it brings so many useful features, we couldn’t wait for the official OpenERP 5 to OpenERP 6 migration script to be released and what a better way to do that than Pentaho Data Integration kit!
So first steps first – create the database via the OpenERP GTK. This installs the base module and populates some db tables with initial data.
Second step – install the needed modules, including any new ones chosen as well as the custom ones if any. In our specific scenario, we had a light custom module, old voucher_payment module and PowerEmail in addition to the other basic modules - accounting, HR, etc. Our custom module was compatible with the new OpenERP version, so no problems there. However we decided to make use of the new official accounting_voucher module instead of the old one as well as use the email_template instead of the PowerEmail. This would require some remapping and additional transformational steps, but nothing is impossible with Pentaho ETL. Once the above is done, time to make a backup of the new database as well as the old one.