Passionate about data

Data and its implications on software design and development.

Database Migration Utility

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.

Migrate DB

This is a simple xml based solution that applies all the changes defined by you in the XML file, you provide a pre-condition or test condition for the execution of the sql and the SQL is executed when the condition is met. The tool provides command line support and also gives ANT integration.

lets take this example build file I’m using this 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)