Pramod Sadalage author of Refactoring Databases: Evolutionary Database Design forwarded an email to the agiledatabases group announcing a new database migration tool (note: the tool is NOT writen by Pramod): dbmaintain
While I am glad that there are others worrying about the lack of basic software development tools in the database realm, I still think we are really missing to things.
First: all these tools are using small migrations, and manage those. I think this is like directly writing patch files and then using some tools to assemble class files from those. Why not maintain one file for creating the schema or the changes from one release to the next. It is much easier to maintain and the version control system will split it into changes if you need it.
Secondly: We now have dbmigrate, migratedb, liquibase, dbmaintain, dbdeploy but none seems to get real traction. Liquibase seems to be most active but even that doesn’t cause enough search traffic to show up on google trends and it is so horribly ridden with XML that I don’t even want to look at it.
We need a JUnit equivalent for database release management. We need somebody with some traction in the community to pick one of those tools and push it forward real hard. Pramod? Martin? Anybody? Please!