There is an internal corporate network and an external server. Located in different domains.

I copy data between databases by SSIS package. In the package there are various SQL tasks for inserting data.

What are the methods of transferring information, because this approach takes a long time? (Insert 14 500 thousand lines takes> 20 minutes)

enter image description here

  • Export - import, direct insert or merge through linked, the latter can be configured as a job. - Nick Proskuryakov 1:01 pm
  • merge does not work, because from the corporate network I see the server, and the external server does not see the internal one, due to the security policy of the company. Now it works by direct insert. - Andrey
  • you can save time if you only transfer changes + You need to understand where the bottleneck of this method is - the request is long on the remote server or the data goes on the network for a long time. optimization strategy will depend on this - Serge Nazarenko

0