Most efficient way to transfer tables between two instances?

[Jake McClellan1]

Hello,

I have two instances and I need to transfer 92 specific tables from instance A to instance B. I have looked at transferring these tables as an XML however going through each one one at a time would take a very long time (go to table on instance A, export as XML, download, go to instance B, clear any existing data from the table in system definition>tables, go to the table, import as XML).

Does anyone know a better way to do this at all please?

Many thanks,

Jake

[Harshal Aditya]

Hi @Jake McClellan1 ,

Could you please confirm if you need to migrate the tables or data in the tables ?

For migrating tables you can use update set.

And for migrating data its manual you would need to pull XML manually form each table.

Please Mark My Response as Correct/Helpful based on Impact

Regards,
Harshal

[Jake McClellan1]

Thank you for your reply.

The tables already exist in both instances A and B, I need the data from instance A onto instance B however. Would that mean that my only option would be to export each individually as an XML?

I have seen that there is a feature called "Export Sets", would this not assist?

Many thanks,

Jake

[Harshal Aditya]

Hi @Jake McClellan1 ,

I am not very familiar with the export set , as far as I know  it helps to transfer the data from serviceNow to external file (sharepoint , remote server etc) so I doubt that it will helpful in our case.

So I could think of two ways-

1. Via XML but its manual

2. You can also explore REST APIs you can try this out in lower instances.

Please Mark My Response as Correct/Helpful based on Impact

Regards,
Harshal

[priyasunku]

Hi @Jake McClellan1 

You can explore Precision Bridge which is used to migrate date from one instance to another instance.

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful