Evolutionary Database Design

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…