Moving table records from one instance to another

[Shibu2]

Hello All,

I have a requirement to move a few ServiceNow tables from one instance to another instance. I have the following questions in regards to that requirement:

1) A table record may have many reference fields. From what I have seen, when a record (for eg. IncidentA) having reference fields is moved from one instance (InstanceA) to another (InstanceB), although the records referenced in those reference fields aren't available on InstanceB, the record (IncidentA) can be migrated and the reference fields would have the non-existent record sys_ids in its place. Later, the referenced records can be migrated and the referenced fields would make a connection to the records. So, is it okay to move a record with reference fields before we move the records referenced in the fields?

2) A table may have a child table, and all records of the child table are present in the parent table (having the same sys_id). So, when migrating these parent-child tables, for eg. Task (Parent) & Incident (Child), should I migrate the parent table (task) before migrating the child table (incident)? From what I have seen, migrating the task, auto-populates the child incident table on the destination instance. In the same way, migrating the child table (incident) auto-populates the parent (task) table. So, would it be okay to proceed from child to parent? Not sure if it would make sense to migrate a incident task before migrating the incident. But, would like to know what would be the right approach.

Let me know if you have any thoughts on the above questions. I really appreciate it.

Thank you.

[Carl Fransen1]

No prpblems and if I have any further thoughts I will post here...

Cheers Carl.

** Please mark answers correct or helpful where assistance has been provided **

[sivakumar90]

I had the same questions while working on a an issue a few weeks back. A resolution to these questions would help a lot. Thank you all.

[anithanarayan]

Hi Shibu / Hi Carl,

The post was really helpful. I am trying to do something similar. Copy the contents of a table (cmdb_ci) from one serviceNow Instance to another. And this table has a lot of references.

I want to achieve this data copy through web services or through some scripting which can be called once in a week through a scheduled job to copy all content (making sure no duplicates)

Is this possible to achieve ?  As i really did not find much content on how to do this. How to track the referenced table content. Should they be moved first or can they be moved later and mapping would be taken care ?

Thanks in Advance, looking forward for a response please.

Regards,

Anitha