Database version control resources
- by Wes McClure
In the process of creating my own DB VCS tool tsqlmigrations.codeplex.com I ran into several good resources to help guide me along the way in reviewing existing offerings and in concepts that would be needed in a good DB VCS. This is my list of helpful links that others can use to understand some of the concepts and some of the tools in existence. In the next few posts I will try to explain how I used these to create TSqlMigrations.
Blogs entries
Three rules for database work - K. Scott Allen
http://odetocode.com/blogs/scott/archive/2008/01/30/three-rules-for-database-work.aspx
Versioning databases - the baseline
http://odetocode.com/blogs/scott/archive/2008/01/31/versioning-databases-the-baseline.aspx
Versioning databases - change scripts
http://odetocode.com/blogs/scott/archive/2008/02/02/versioning-databases-change-scripts.aspx
Versioning databases - views, stored procedures and the like
http://odetocode.com/blogs/scott/archive/2008/02/02/versioning-databases-views-stored-procedures-and-the-like.aspx
Versioning databases - branching and merging
http://odetocode.com/blogs/scott/archive/2008/02/03/versioning-databases-branching-and-merging.aspx
Evolutionary Database Design - Martin Fowler
http://martinfowler.com/articles/evodb.html
Are database migration frameworks worth the effort? - Good challenges
http://www.ridgway.co.za/archive/2009/01/03/are-database-migration-frameworks-worth-the-effort.aspx
Continuous Integration (in general)
http://martinfowler.com/articles/continuousIntegration.html
http://martinfowler.com/articles/originalContinuousIntegration.html
Is Your Database Under Version Control?
http://www.codinghorror.com/blog/archives/000743.html
11 Tools for Database Versioning
http://secretgeek.net/dbcontrol.asp
How to do database source control and builds
http://mikehadlow.blogspot.com/2006/09/how-to-do-database-source-control-and.html
.Net Database Migration Tool Roundup
http://flux88.com/blog/net-database-migration-tool-roundup/
Books
Book
Description
Refactoring Databases: Evolutionary Database Design
Martin Fowler signature series on refactoring databases.
Book site: http://databaserefactoring.com/
Recipes for Continuous Database Integration: Evolutionary Database Development (Digital Short Cut)
A good question/answer layout of common problems and solutions with database version control.
http://www.informit.com/store/product.aspx?isbn=032150206X