Database version control resources

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

Posted on Thursday, March 4, 2010 2:53 PM | Back to top