3.4.2010

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


db vcs 



comments powered by Disqus