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

See http://www.clevercomponents.com/products/datapump/ibdatapump.asp

That's not Java tool, but I suspect that you will be able to find a
Windows computer where you can run this tool (possibly it will also
run under Wine).

Roman