I have taken up the hobby of searching the opensource landscape for tools that help me do Agile database development. I’m going to write about all the Tools that I come across that help me, my preference is opensource software but not limited to it. I will try to provide some sound examples and share my experiences with all that tools that I come across and share the example code I used.
lets take this example build file I’m using this build.properties file to define my connection properties
I created a ANT task named as dbrelease, used the ANT task to create a ANT target named as migratedb. The ANT target uses a XML file to write a pre condition SQL and the actual SQL to migrate the DB. example XML can be found here.
Full example can be found here ( is a zip file and contains the migratedb.jar all the xml files and is setup to work with oracle)