title: Sql server express
body: <p>I have two computers in same local network. </p>
  
  <p>One computer (comp1) have sql express database and have main application and other computer (comp2) have client application which need to access to data in sql server. </p>
  
  <p>The problem is, how to ensure when comp1 is turned off that a comp2 has the latest data with him before the shutdown comp1 (offline mode). Comp2 work with offline data (select , insert data local) and when comp1 is turned on data from comp2<br>
  synchronized with sql server. </p>
  
  <p>What is best practice to ensure this? I must use only sql server express because it is free. </p>