Auto-update script from dumps?

Hi!

What I'm looking for is something that handles DB schema upgrades. We're
building applications which require upgrades to the DB schema over time, so
when we upgrade our apps we need to modify the DB. For this, we're using SQL
scripts, which basically do incremental updates, e.g. from 1.2 to 1.3. So
when we upgrade FooBar Version 2.3, which uses DB schema 1.3 to Version 3.9,
which uses DB schema 1.9 we would run 6 scripts, and voila, we would have a
1.9 schema.

OK, sounds simple. But it's sometimes a lot of work to build the update
script, and easy to miss something. So I was just thinking whether there's a
tool or script out there that builds an update script from two different
schema dumps. Does anyone out there know of such a beast?

Greetings,
Jörg
--
Leading SW developer - S.E.A GmbH
Mail: joerg(dot)hessdoerfer(at)sea-gmbh(dot)com
WWW: http://www.sea-gmbh.com