Go here for the other posts in this series.
MIGRATEdb will parse an XML file of database changes and load them to the targeted database if they are not already there.
A database change consists of a test to determine whether the change has already been applied and a set of change actions.
The tool works from the command line and also as an Ant target. For a simple start we have an Ant script that includes targets for:
- user.xml = create the application user (this will be executed by an existing ‘power’ user with the permissions to create a schema/user)
- db.xml = all application creation SQL
- drop.xml = drop (cascade) the application user (I expect this would only be used in my development sandbox)