title: What is a good practice/tool for MSSQL database design and versioning?
body: <p>We work with a small development team and a system engineer who deploys the software at certain times.</p>
  
  <p>At the moment we don't have any leading document for database changes. Changes are done in the staging database and added manually to production when the system engineer deploys a new release.</p>
  
  <p>We started to work with DBDesigner Fork to create the design and generate the SQL create script, but we are still not happy with this solution. The solution is incomplete, because it's impossible to create views and stored procedures in DBDesigner Fork for example.</p>
  
  <p>We would like to find a practice/tool to design the database, stored procedures, views, etc. and version the changes in Subversion.</p>
  
  <p>When a new software release is created (tagged in SVN), we should be able to create a patch file for the database (a SQL script for example).</p>
  
  <p>What is the best way to handle the issues described above?</p>