title: Export 13 million records from SQL Server DB1 to another SQL Server DB2
body: <p>I have been asked to dump about 13 million rows from a SQL Server 2008 R2 database to another SQL Server 2008 R2 database, but both are on different database servers, and they have no common login.</p>
  
  <p>It seems writing a C# program that uses ADO.NET SqlBulkCopy class is the only option and even with this, the program needs to run repeatedly every 'x' minutes till all data is copied.</p>
  
  <p><strong>Is there any other better way to do this huge data transfer?</strong></p>