--- In Firebird-Java@yahoogroups.com, "Steffen Heil" <lists@s...> wrote:

> 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

Yes, thanks for that, I know what has to be done in an SQL sense,
that's what worries me! ;-) With 45+ source tables, 90+ destination
tables and 350+ columns, the amount of SQL to write will be horrendous!
So that's why I'm after a tool - eg a gui that shows a source table on
the left, destination table on the right, and I can drag a left-hand
table column to a right-hand table column. This is recorded and SQL
created from it. Obviously this wouldn't work for all the data
manipulation, but would get rid of some of the drudgery.
It'll also be easier to maintain as the destination datamodel evolves
(as I'm sure it will through the life of the project).
Maybe I'll have to write one with swing & java2D....

Thanks