True ... the for the day's work, you have to migrate the structure
yourself using other tools, or (as in my case) have an predefined target
database that is being migrated to.

I actually used XSLT in between the databases to convert the old
structures into the new structures in migration. That's why it took 3
days instead of 1 to put the tool together.

On Tue, 2005-08-02 at 14:12 +0200, Martijn Tonies wrote:
> David,
>
> > The tool I use is called JDBC.
> >
> > Read rows from the Firebird database using the Jaybird driver, and write
> > the rows to Oracle using the oracle thin JDBC driver. By making the
> > input and output drivers configurable, you have a generic datapump for
> > about a day's worth of work.
> >
> > With about 3 day's work I put together a tool that is replacing (and out
> > performing) a $100,000 / year ETL tool.
>
> DataPump <> structure migrator.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>