How to: database versioning with maven2?

问题:

I am finding any maven plugin for versioning database changes.

回答1:

There are a few plugins that offer some support for this task:

• Maven LiquiBase Plugin
• Maven Database Migration Plugin
• DbMaintain Maven Plugin (a plugin for DbMaintain, the famous tool from Unitils)

I don't have much experience with them, we currently use a custom tool to apply our change scripts. But the Maven Database Migration Plugin is a serious candidate to replace it. LiquiBase is pretty famous but also different, changes are described in a generic XML format. About DbMaintain, it works well (in Unitils) but I've never tested the wrapper plugin mentioned above.

回答2:

Here is one more, it's simple to use and has excellent support for Mysql stored procedures:

Flyway Maven Plugin

回答3:

I used this one http://jsoftware.org/maven-dbpatch-plugin

It supports rollback patches too.