title: 1 sql with 2 different sqlconnections using c#
body: <p>I have 2 different connections located on different sql servers, Source Server and Target Server.
  I want to compare a table that exists in both servers and align the Target Server table with the Source Server one.</p>
  
  <pre><code>SqlConnection src = (DataBaseConnection.GetSqlConnection());
  
  SqlConnection trg = new SqlConnection(Properties.Settings.Default.IDCConnectionDEV);
  
  src.Open();
  trg.Open();
  
  SqlCommand source = new SqlCommand("SELECT * FROM Source table", src);
  SqlCommand traget = new SqlCommand("SELECT * FROM Target Table", trg);
  
  SqlDataReader drsrc = source.ExecuteReader();
  SqlDataReader drtrg = traget.ExecuteReader();
  
  DataTable tbl1 = new DataTable();
  tbl1.Load(drsrc);
  
  DataTable tbl2 = new DataTable();
  tbl2.Load(drtrg);
  </code></pre>
  
  <p>Now my question is how do i run the following query:</p>
  
  <pre><code>(select * from Source table) except (select * from Target table)
  </code></pre>
  
  <p>or any other sql query using tables from both connections.</p>