Hi

> 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.

How about renaming the old tables to sth like O_tablename and creating empty
new tables with N_tablename.
This can be done by a script.

The write one (or more) stored procedures, that convert your data and run
it.
(Inserting this into the database and starting it can also be done by a
script).

Finally delete old tables and rename the new ones.
Also done by a script.


All together, you need just ISQL and your script.

Remember to add / remove foreign keys and such things before renaming your
tables.
And remember, that renaming is not possible directly. (But if your table
names are distinct, you can skip it.)

At least, you get the idea.

Regards,
Steffen