OPENROWSET performance for copying data from one server to another server

Question

• Can we write a query like

  INSER TNTO clients SELECT * FROM OPENROWSET ("SQLNCLI", "Remote Server Settings", "SELECT * FROM Customers")

  The remote server is located on some other server through the public IP address of the Internet.

• Will it be faster compared to SqlBulkCopy?

I need to create a working database that can regularly copy data from a server accessible via public IP

Does anyone have an idea of ​​timeouts and failures in large value tables?

Answer 1

, OPENROWSET , , , .

db .

Answer 2

, .

http://msdn.microsoft.com/en-us/library/ms151319.aspx

Answer 3

SQL Server 2008, Change Data Capture, Delta .

http://msdn.microsoft.com/en-us/library/cc645937.aspx