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

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.
1 answers

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