Question

Upgrade to Mendix 4.7 (from 3.3.7) How to keep current ID values

1

Addition to increasing the size of the ID fields the upgrade script changes the ID values. Is there a way to upgrade without changing the ID values. i.e. that the script only update the field size from NUMBER(10) to NUMBER(20) but leave the current data's values as is. We have BI data extracted from our system and by changing the ID values will cause a major disruption. Besides that the upgrade will take forever.

asked 2013-11-26

Frankie Dumas

1 answers

Sebastiaan van den Broek · Answer 1 · 2013-11-26

No there is no way to do this. However, you can still figure out the old ids using bitshifting, by taking the 48 least significant bits of the id. For more information, check out https://forum.mendix.com/questions/4441/Insert%20records%20in%20database%20using%20SQL