title: SQL Server Database schema versioning and update
body: <p>For my application I have to support update scenarios and the database might be affected. </p>
  
  <p>I want to be able to update from an old version to the newest without installing intermediate versions. E.g. Suppose I have version A (the oldest), B (intermediate) and C (new version). I want to be able to update version A straight to version C. For the application files this is simple, I just replace the old with the new ones. However for the database I do not wish to generate a SQL Script to change the database schema from A straight to C, instead I want first apply a script to change the schema from A to B and from B to C. </p>
  
  <p>How can I store the database version for a SQL Server database? Is there any special property which I can set, instead of implementing a version table? In my code (.NET) I want to read the database version and accordingly to execute the update SQL scripts in the proper order.</p>
  
  <p>I will use both SQL Server 2005 and SQL Server 2008.</p>