Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

Sys_Id: retain existing or generate new during data migration?

Chenlin
ServiceNow Employee

Hi,

I'm seeking for a guideline on sys_id handling:

When migrating data from one system to another, in general should record sys_id be copied to new system, or let the new system to generate new ids?
Note that it's between two different systems, rather than different instances (e.g. Dev, QA, UAT, Stage, etc.) of the same system.

 

I was from SQL server background and in that domain it was strongly suggested to leave it to the platform for performance consideration (so that guid are generated sequentially), but it seems ServiceNow platform might not have the same constraint.

 

Please advice,

Thanks!

0 REPLIES 0