Migration from ADempiere 3.60LTS to iDempiere, best path?

[nilskm]

ADempiere 3.60LTS on Postgresql 9.2. 

Should I start with upgrading the DB from 9.2 to a more modern version or should I start with applying the migration scripts? 

And where can I find the migration scripts? They links on this page are broken: 

https://wiki.idempiere.org/en/Migration_Note

Best regards

Nils

[nilskm]

I've found the integration scripts. But has anyone written a guide on how to use them? 

idempiere/migration-historic at master · idempiere/idempiere · GitHub 

[Aziz Kayoueche]

Hi 

Having worked with Compiere and ADempiere in the past, and now working on iDempiere, I've noticed some key differences. While I am not a migration expert between these two ecosystems, I want to point out that the database structures are not identical.

For example, in ADempiere, storage is handled by a single table: M_Storage. On the other hand, in iDempiere, this has been split into two separate tables: M_StorageOnHand and M_StorageReservation.

I hope you find this information helpful.

[edwin_ang]

You are trying to do a very huge migration effort. 

Migrating from Adempiere to iDempiere then you have to upgrade multiple versions, with critical checkpoints at version 6, 8 and 11. 

If you have minor customization on your current Adempiere system then this will be easier.

But it will still be a major effort. If you don't have enough resources (time and money), then i would suggest you to just skip migration. Just start over in iDempiere version 11 or 12 and create a data warehouse to archive your existing Adempiere data. 

[Nils Kohlström]

Thank you for your replies! It'll probably end up with starting over completely with the latest version of iDempiere. This was mostly just a test to see how it would work out. 

I'm still interested in what's the best path to run the db scripts. To upgrade Postgresql first and then run the db scripts? Or maybe it's more complicated than that

--
You received this message because you are subscribed to a topic in the Google Groups "iDempiere" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/idempiere/R30tD1Tan6g/unsubscribe.
To unsubscribe from this group and all its topics, send an email to idempiere+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/idempiere/0da927a5-80a3-4f8c-b80e-dae8d5f67dden%40googlegroups.com.

[Edwin Ang]

The tricky part is Adempiere and the old version of iDempiere are using an old version of PostgreSQL JDBC driver. We've done an upgrade project two years ago from version 2 to 11 and it was a massive effort. We've done it in three phases: 2 to 6.2, 6.2 to 8.2 and then 8.2 to 11. We need to upgrade PostgreSQL in several phases too. 

The older version of iDempiere has an ant script that can automate running the migration scripts. 

I would say if it is not a huge and critical installation, then just don't even try it. Very expensive and risky project.

To view this discussion visit https://groups.google.com/d/msgid/idempiere/CAEd1mAX7PFBtAMK_Wzjtx%2Bru7RsNMGWxnYXZoTUzNLX66BwwFQ%40mail.gmail.com.

[Nils Kohlström]

Thanks! I was kind of afraid of the necessity to upgrade PostgreSQL in steps too, and that it would be kind of hard to know where and how. But I have tested 3.60LTS with PostgreSQL v16. Just using the latest jdbc driver did the trick. I haven't tested everything but still a lot and I haven't experienced any trouble at all. Therefore I thought it could be easiest to upgrade to PostgreSQL v16 first and after that start testing the db scripts. I think I'll give it a try anyway :) 

To view this discussion visit https://groups.google.com/d/msgid/idempiere/CAP4vBhh79g1Nf6HEqY4rNMt1LvZNi%3DKieuBKw8cV-_QAeVL_-g%40mail.gmail.com.