Amazing world about data

Developer, ThoughtWorker, Data Architect and Data Specialist

Database Migration Utility

Database migration framework

1 minute read

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)

Recent posts

Post

See more

Categories

About