Managing database change in an automated fashion can be a complex affair. Building on patterns outlined in co-worker Pramodkumar J. Sadalage & Scott W. Ambler’s Database Refactoring book, dbdeploy helps manage database refactorings. Used across many projects worldwide – and with ports in at least two languages – I worked on the initial Java version, although colleagues Graham Tackley (now at the Guardian) and Nick Ashley did most of the heavy lifting. Graham is now the main maintainer.
You can find more information on the dbdeploy website.