title: Transfer data from one SQL Server table to another
body: <p>For example I have one SQL Server database that contains a table</p>
  
  <pre><code>Id          Address
  1  England,London,someaddress
  2  Germany,Berlin,someaddress2
  </code></pre>
  
  <p>And I have another SQL Server database that contains following table with scheme</p>
  
  <pre><code> Id  Country City Address
  </code></pre>
  
  <p>I need transfer data from first database to second. Like this.</p>
  
  <pre><code>id  Country    City    Address
   1  England   London   someaddress
   2  Germany   Berlin   someaddress2
  </code></pre>
  
  <p>How can I do that?</p>