title: Automatically update SQL Server database schema
body: <p>I have deployed a C# app and my customers benefits from new deployed versions by ClickOnce update.</p>
  
  <p>But I have trouble when I change to the application database schema because the customers cannot benefit from auto update database changes, please give me the solution how can I let customer app to check if the new version of DB is available then do the update.</p>
  
  <p>So there are two problems:</p>
  
  <ol>
  <li>how does customer app check for DB schema new version?</li>
  <li>how to perform update with avoid to loss customer data just update schema?</li>
  </ol>