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.hessdoerfer@sea-gmbh.com
WWW:  http://www.sea-gmbh.com