title: SQL Server - synchronizing 2 tables on 2 different databases
body: <p>I have 2 tables with same schema on 2 different databases on the same server with SQL Server 2008 R2.
  One table gets updated with data more often.</p>
  
  <p>Now there is a need to keep these 2 table in sync. This can happen as a nightly process.
  What is the best methodology to achieve the sync. process ?</p>