Instance to instance data migration

[Rushi2]

Hi All, 

we are planning to migrate data one instance to another instance. we find same sys_id in both instances . 

if we will export XML it is override exsiting data. anyone has any idea how to move data .

I need to move HR data and those relationships and attachments everything .

Please let me know if there is any best way to do it ?

Regards, 

Rushi

[Yousaf]

Hi Rushi,

Here are the few options to take a look at whats best in your case.

Migrate Data from one instance to another

Mark Correct or Helpful if it helps.

[Community Alums]

Hi Rushi,

That is the expected behavior !! That's how it works right , you should maintain the same SysID's.

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.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep