title: How to sync two sql-server tables from different location?
body: <p>I have a database at HQ and another one at branch. Both database is identical, all the schema is the same. It could be more than one branch.</p>
  
  <p>For example, the branch has a local database with a table called Sales, all transaction will be inserted into the table. Every night, when the shop is close, all the sales information from the branch will be synchronize with HQ database. Only the record not in the HQ database will be inserted or updated.</p>
  
  <p>How can I do it in a very efficient method, small and light, reconnect when the connection is down, because the internet bandwidth is limited and constantly dropping.</p>
  
  <p>How can I do synchronize from HQ to all branches with the latest products and price?</p>
  
  <p>Should I write a web services?</p>
  
  <p>Thank you.  </p>