title: Merging tables with same name and schema in different databases
body: <p>I have this table A in UAT with the following schema</p>
  
  <pre><code>A-UAT
  
  Column 1,
  Column 2,
  Column 3
  </code></pre>
  
  <p>I have the same table in prod with the same schema</p>
  
  <pre><code>A-Prod
  
  Column 1,
  Column 2,
  Column 3
  </code></pre>
  
  <p>New rows were added to UAT recently and at that time UAT did not have all the records of the Prod table. Now, I want to merge the newly added rows in UAT with prod. That is, whatever was newly added in UAT alone should go into prod without disturbing whatever was existing there already. Is there a way to do this in MS SQL server 2005/08? </p>