Topic: Prompt about data migration between servers. Import is eliminated, unless in a file.
There are some servers, more than three, dataful. With similar on a format, but the data different in the content.
It is necessary, with certain periodicity, to select a certain data set, from servers of sources and to add result of request in the table on absolutely other server, the receiver.
As it is necessary to eliminate as much as possible from this operation of people, in sense on a maximum to make means of jobs of the agent.
While I see only results of requests to add in XML, to transfer XML files to the server the receiver and on it from XML to transfer the data to basis the receiver.
Can people already solved similar tasks?
The full access to servers to sources is not present, only the receiver. But to ask/force administrators to make and procedure it it is possible, as scripts of requests I will give.