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

[Ankur Bawiskar]

@Jake McClellan1 

Were those tables and table fields not captured as part of any update set intentionally?

If you would have captured in an update set then migration would have been easier from instance A to instance B