title: How to sync online & offline databases
body: <p>I have a <strong>web application</strong> which provide some information for my customers. I have another version (<strong>windows</strong>) that <code>exactly work same as web application</code>.</p>
  
  <p>This is because Web connection may lost for some hours and in this time user is going to use the application.</p>
  
  <p><strong>I'm wonder how to sync these <code>SQL Server</code> databases.</strong></p>
  
  <p>Note that web application is using from <code>3 different cities</code> and <code>all of them have a windows based application too</code>. What should I do?</p>
  
  <p>NoteL windows verision is exactly web application which installed in the Local Web Server in 3 different cities and users have access to them via their <code>LAN</code>.</p>