Update Items and Locations in Demantra Database

Hi, in my company, we are changing the ERP and we are going to update all the Items and Customers IDs.

We have Dementra since 4 years ago, we want to maintain the sales history, so the question is

How can I update the Demantra Items and Locations data? (in the database)

I can create a mapping table with Old IDs and the new ones, but what do I have todo?

Your help is really appreciated!

Diego.