continuous integration with mysql

Question

My entire environment, java, js, and php are set up with our continuous integration server (Hudson). But how do I get out database into the mix?

I would like to deploy fresh MySql databases for unit testing, development, and qa.

And then I'd like to diff development against production and have an update script that would be used for releasing.

Answer 1

I would look at liquibase (http://www.liquibase.org/). It's a open source java based db migration tool that can be integrated into your build script and can handle db diffing. I've used it before to manage db updates on a project before with a lot of success.

Answer 2

You could write a script in Ant to do all that stuff and execute it during the build.