http://blogs.msdn.com/b/buckwoody/archive/2009/01/27/versioning-the-database.aspxIf you write apps that hit a database that you own, then you probably want version control on the database itself. I always script out the initial database, and version that script. I also script the changes, and version those, and then script the entireen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/buckwoody/archive/2009/01/27/versioning-the-database.aspx#10072480Wed, 06 Oct 2010 22:51:02 GMT91d46819-8472-40ad-a661-2c78acb4018c:10072480Brian Krebs<p>I like that you are attempting to solve an age-old IT conundrum in a pragmatic way. &nbsp;I see a couple of downsides to your approach though, and you mentioned a few in your final paragraph. &nbsp;There is really no true control since the user can change objects without checking in.</p> <p>A new, innovative software product called DBVS solves all of these problems in an elegant way. &nbsp;When a database object is checked in, the DBVS server connects to that database and extracts the object&#39;s metadata in an XML format and versions it in a SCM tool of your choice. &nbsp;That means there is no need to version SQL scripts at all.</p> <p>Find out more about DBVS at <a rel="nofollow" target="_new" href="http://www.dbvsys.com">http://www.dbvsys.com</a>. &nbsp;Comments and suggestions are always welcome. &nbsp;I&#39;d be interested to hear your thoughts.</p> <p>Brian Krebs</p> <p>Chief Technical Officer</p> <p>Database Versioning Systems</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10072480" width="1" height="1">http://blogs.msdn.com/b/buckwoody/archive/2009/01/27/versioning-the-database.aspx#9382380Thu, 29 Jan 2009 07:43:52 GMT91d46819-8472-40ad-a661-2c78acb4018c:9382380Bill Ramos<p>Funny you should bring this topic up on the same day that I recieved my plaque for versioning database objects using source control systems from back in 1999. Check out <a rel="nofollow" target="_new" href="http://tinyurl.com/dlynbv">http://tinyurl.com/dlynbv</a></p> <p>Bill Ramos</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9382380" width="1" height="1">