So for the migration what process you are using?
For this case you can use transform map.
To avoid duplicate records while migrating from one instance to another in ServiceNow, you can follow these steps:
1. use 'sys_id' as a coalesce field as it is a unique identifier for each record in ServiceNow.
2. Use Coalesce: ServiceNow provides a feature called coalesce which can be used while importing data.
Coalesce is a property of import set transform map that determines if an incoming record matches an existing one.
3. Set Coalesce Fields: In the transform map, set the field or fields that should be used to check for duplicates. If a match is found, the existing record will be updated with the new information.
See this link to understand the transform map : Servicenow Transform Map Script Example | Data Source & Import Data into ServiceNow Instance
Kindly mark the answer ✔️Correct or Helpful ✔️If it addresses your concern.
Regards,
Siddhesh
