Export and Import of Existing Table data from one instance to another instance.

[1_DipikaD]

Hi All,

I want to move lots of records of a custom table from lower instance to the same table in higher instance.

But I have made certain changes in those records like I  made active = false for few records and changed some field values for lots of records. So I want to know if I migrate those records via export and import xml method it will update the existing records in higher instance or it will create new records ?  I am not trying import set method, I just filter out required records from table and export to xml from list view and trying to import it on the same table on higher instance. 

Thank you

[Runjay Patel]

Hi @1_DipikaD ,

XML would be the right path to migrate the data.

It will create new record if not present in Prod and if found then it will update the record. System will check sysid, if both instance have different sysid for same record then instead of updating it will create new record.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------