title: SQL INSERT INTO SELECT Statement between two different databases
body: <p>sometimes I need to move data from one database table to another table in different database. These tables are identic. So I am trying to make program in C# Winforms, but I cant figure it out. 
  I think that I should use this:</p>
  
  <pre><code>INSERT INTO table2
      SELECT *
      FROM table1
      WHERE condition;
  </code></pre>
  
  <p>But how can I execute this sql command when I need two connections? Or what is the right approach?</p>
  
  <p><strong>EDIT:</strong> They aren't on same server. Any other option than throught Linked servers?</p>