title: Copy data from one SQL Server database table to the other
body: <p>I would like to copy the data from one table to another between different servers.</p>
  
  <p>If it is with in the same server and different databases, i have used the following</p>
  
  <pre><code>SELECT * INTO DB1..TBL1 FROM DB2..TBL1 (to copy with table structure and data)
  
  INSERT INTO DB1..TBL1(F1, F2) SELECT F1, F2 FROM DB2..TBL1 (copy only data)
  </code></pre>
  
  <p>Now my question is copy the data from SERVER1 --> DB1--> TBL1 to SERVER2 --> DB2 -->TBL2</p>