How to migrate table data from one instance to another instance

[Ranjana Goel]

Hi,

How to migrate table data from one instance to another instance without loosing the reference and ID's? Is there any servicenow tool available for data migration?

Thanks,

Ranjana 

[Riya Verma]

Hi @Ranjana Goel ,

Hope you are doing great.

 To migrate table data from one instance to another instance without loosing the reference and ID's?

1. In the source instance, export the data from the table you wish to migrate using the data export functionality. Export the data from record using below link, this link will export using sysid : https://instance.service-now.com/incident_list.do?CSV&sysparm_default_export_fields=all

2. In the target instance, configure an Import Set table that corresponds to the table you are migrating. Import Sets act as staging tables where you can load data for further processing.

3. Create a Transform Map in the target instance to map the fields from the Import Set table to the destination table. Ensure that the field mappings are accurate, considering the relationships and references within the data.

4. load the exported data into the staging table in the target instance. This can be done by importing the CSV or XML file generated in step 1.

5. Transform Data: Once the data is loaded into the Import Set table, apply the Transform Map created in step 3 to transform the data from the staging table to the destination table. This step ensures that references and IDs are maintained correctly during the migration process.

6. Validate the transformed data to ensure the mappings and transformations are accurate. Once validated, commit the data to transfer it from the Import Set table to the destination table in the target instance.

[Ranjana Goel]

@Riya Verma Thanks for sharing detailed steps Riya. This is really helpful. Let me try these steps and I'll get back to you.

[Dr Atul G- LNG]

Hi @Ranjana Goel 

Greetings!!

Before you implement the solution, need to know what do you mean by Data. Data ( Transactional data) movement from one instance to another is not recommended but if you want to move Foundation data 

- You can use XML way to move the data from one to another instance without loosing any reference.

- In case data is huge , try to break in chunks so that import will be easy.

In case you want to bring data in first instance, you transform map method.

https://youtu.be/9yhJvPnK1Jk

https://youtu.be/5MTMt7v35xs

Please mark this response as correct or helpful or solution accepted if it assisted you with your question.

Regards
Atul G.
Learn N Grow With Atul G

- 

[2022_ServiceNow]

Hi @Ranjana Goel,

• To export the table & data, we need to export the table as xml from the dictionary and then import it to the required space.
  • Go to dictionaries. Then, export it as XML and in the target, go to dictionaries and import it as XML.

• This step should be done for both Table and values in the table separately.
• If there is already the table in the other instance, then go to dictionary, search for the table and then import values.