Using XML import sets

Use an XML import set to import data from another instance.

This method allows you to:

• Apply business rules
• Transform incoming data
• Reconcile sys_id values if necessary

Note: Administrators cannot set the update_synch attribute in Dictionary records to move data as part of update sets. This attribute was being used incorrectly to migrate data in large tables and was causing significant performance problems.

1. Create an XML data source to another instance
   Data sources are used to create an import set so that data can be processed, if necessary, prior to being mapped onto a production table.
2. Create a transform map
   A transform map is a set of field maps that determine the relationships between fields in an import set and fields in an existing ServiceNow table, such as Incidents [incident] or Users [sys_user].
3. Add onBefore scripts to the transform map
   Create one onBefore transform map script to copy the sys_id of new records from the source to the target instance. Create a second onBefore transform map script to identify records on the target instance that have the same unique values but different sys_id values.

Parent Topic:Importing from another ServiceNow instance