title: What is the best way to achieve data sync between SQL Azure and Multiple On-Premises SQL server databases?
body: <p>I have a scenario as explained below and I need to implement the best Data Sync method.</p>
  
  <ol>
  <li>I have a centralized SQL Azure database (master Database)</li>
  <li>There are about 20 (this will increase in future) on-premises SQL Server Databases. These database are not necessarily always connected to the internet.</li>
  <li>All master and on-premises DB's will have the same schema/table structures.</li>
  <li>I would like to do bidirectional data sync between all on-premises databases with SQL Azure and vice-versa.</li>
  <li>Data Sync frequency will be once in a day.</li>
  <li>Each on-premises DB size is reasonable(not too big and not too small).</li>
  </ol>
  
  <p>These below options I have explored:</p>
  
  <ol>
  <li>SQL Azure Data Sync</li>
  <li>Microsoft Sync Framework</li>
  <li>SQL Server 2008 Change Data Capture</li>
  <li>SQL Server Change Tracking</li>
  </ol>
  
  <p>I would like to know the best possible method to achieve this.</p>