title: How do I keep databases in sync when internet fails
body: <p>I'm doing some work for a company that has 5 warehouses and a home-grown Inventory Management System which uses a SQL server database in the cloud.  The problem is if one of the warehouses loses internet connectivity all activity ceases.  The IMS is useless without its database.</p>
  
  <p>Is there some way we could run off local copies of the database, which would sync up with the main database when the internet connection is restored?</p>
  
  <p>I've searched the archives and there are a lot of relevant posts but many refer to products or technology which no longer exists. Others assume the reader is smarter than I am! </p>
  
  <p>We can move the database to Azure of AWS if that would be helpful.  Any ideas?  Thanks.</p>