liquibase

Testing database refactoring with liquibase, base on this post http://architects.dzone.com/articles/source-control-your-database#.Uw6f9LOQ1l0.twitter

in the folder src/main/resources/db.changelogs my-changelog-master.xml (is the master changelog in XML format) my-changelog-master-sql.xml (is the master changelog in SQL format)

I'm using a mysql database, the credentials are in the pom.xml

org.liquibase liquibase-maven-plugin 2.0.1 db.changelogs/my-changelog-master.xml com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/MyDB username pasword update

you can change the changeLogFile property to use the master changelog in XML format or the SQL format

to update the database, you can run this maven command:

mvn liquibase:update (updateSQL generates the SQL sentences without executing them in order to check the script that is generated)