Continuous integration with mysql

Question

My whole environment, java, js and php is configured on our continuous integration server (Hudson). But how do I get the database in the mix?

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

And then I would like to deploy development against production and have an update to the script that will be used for release.

Answer 1

I would look at lipibase ( http://www.liquibase.org /). This is a Java-based open source db migration tool that can be integrated into your build script and can handle db diffing. I used it before to manage db updates in a project before with great success.

Answer 2

You can write a script in Ant to do all this and execute it at build time.

Answer 3

, , migrate4j.

Answer 4

script, . , , , . , ; maven. .

Answer 5

HyperSQL DB (http://hsqldb.org/) ?

Answer 6

, Scala: http://opensource.imageworks.com/?p=scalamigrations

, , , Java, , - Scala.

.

Answer 7

Give http://code.google.com/p/mysql-php-migrations/ a try! Very PHP oriented, but seems to work well for most purposes.