This post originated from an RSS feed registered with Agile Buzz by Martin Fowler. Original Post: Evolutionary Database Design Feed Title: Martin Fowler's Bliki Feed URL: http://martinfowler.com/feed.atom Feed Description: A cross between a blog and wiki of my partly-formed ideas on software development Latest Agile Buzz Posts Latest Agile Buzz Posts by Martin Fowler Latest Posts From Martin Fowler's Bliki

When we began to do agile software development at the turn of the century one of the big questions was how to evolve databases. In 2003 Pramod Sadalage and I published an article on the techniques we used, now we've updated this article to reflect a decade's worth of learning since then. The core techniques are still the same: organize database changes into composable migrations that capture schema refactorings and data updates. Store these migrations in the code repository and use tools to apply them to keep the database synchronized with the code.

more…