Hi, can anyone recommend any good java database migration tools? We
are moving from one system (with a proprietry storage mechanism) with
denormalised data (45+ tables) to a new normalised datamodel with 90+
tables in Firebird.

Our first step has been to extract the data from the old system into
an equvalent database structure in Firebird. Next we need to map this
data into our new database (with the different structure). (Too much
of a headache going from the old proprietry system to the new
datamodel all in one step.)
Very few tables can be kept as-is when going from the old to the new
structure, so it isn't just a case of selecting rows in old database
table A and putting them in new database table B.

A graphical tool would be good, as long as the final migration script
can be run without a gui (or at least automatically). This needs to be
automatic as it'll be run at over 1000 sites.

Thanks