Apr 16

Agile Database - Part 4: MIGRATEdb (a solution to the release problem)

Tag: , , — warren @ 2:26 pm

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)

2 Responses to “Agile Database - Part 4: MIGRATEdb (a solution to the release problem)”

  1. werutzb says:
    October 8th, 2008 at 12:01 pm

    Hi!

    I want to improve my SQL capabilities.
    I red that many SQL books and want to
    read more about SQL for my work as mysql database manager.

    What can you recommend?

    Thanks,
    Werutz

  2. warren says:
    October 13th, 2008 at 7:42 pm

    I am not a MySQL specialist. I would have a look at a few books in my local bookstore, or type Mysql into Amazon and read about what comes up.

Leave a Reply