Just sharing some of my inconsequential lunch conversations with you... RSS  

Tuesday, February 05, 2008

Get control over your database

Or "Get Your Database Under Version Control", as compiled by Jeff Atwood:

K. Scott Allen just wrote a brilliant five part series on the philosophy and practice of database version control:

  1. Three rules for database work
  2. The Baseline
  3. Change Scripts
  4. Views, Stored Procedures and the Like
  5. Branching and Merging

Managing your database versions is just darn hard. In my opinion, the schema itself is the easy part, data is often the problem - at least on unstable staging scenarios that derive from production data.

No comments:

Development Catharsis :: Copyright 2006 Mário Romano