Sys ID is changing while moving data from one instance to another

[Ajai S Nair]

Hi All,

When we are trying to move data from one instance to another by uploading through Excel sheet, the Sys ID is changed. If we are using XML then there is no change in Sys IDs.Can anyone help me out to find out the reason?

Regards,

Ajai

[Deepak Ingale1]

Risk associated with solution I suggested is, if there is any Reference field and that 'sys_id' is not listed in destination, it will not throw any error of missing sys_id , rather once you   are done with manual import, you will see just a 'sys_id' present on the reference field.

[Anurag Tripathi]

This is the expected behavior, as when you export in excel the sys_id does not get exported. Now when you import this , new sys_id's will be generated for these records.

[Ashish Kumar Ag]

I think you are confused with update set and Import of excel.

During you committee any update set it also holds the sys_id. so in different instance you have same sys_id.(Like through XML)

Importing through excel is just like creating a record manually, so sys_id is random.

This is expected.