yes ,you are right

The senario is that we dont have connection between both servers.

And it is required to copy data from some tables of one server to another.

Both servers already have the same...

The requirement emerges from client's constraints. No connection(like VPN) is availabe between branches and head office. They need some utility which generate some "thing" (which will indeed be scripts) and...