Import Wizard Question

[Former Member]

Hi

We are planing to migrate from R1 to R2 and plan to use the Import Wizard for the migration.

I notice that a new ID number is assigned to the imported objects in R2. We have some custom processes in place that key off of the R1 ID and would like to keep the R1 ID within R2 if possible.

When I say "ID number" I'm referring to the number in bold (2055).

frs://Input/a_007/008/000/2055/~ce143854e748aa220.rpt

Is it possible to import the object and retain the R1 ID number?

Thanks.

[BasicTek · Accepted solution]

Also to note when you migrate via import wizard your si_id will always change as you stated whether migrating versions or from different environments. If you have objects that are referencing the si_id you should change that to the cuid. For instance if you plan to set up multiple environments and migrate data with the import wizard from DEV to Prod, this will always change the si_id. Therefore if you change these types of reports to key off the cuid then this will not be an issue. I'd need to know more specifics of how you are referencing the si_id to explain in more detail.

Regards,

Tim

[Former Member]

You may want to try to upgrade by using the copy database option in the CMC and then repoint your input and output frs. This should keep your ID's.