Have you checked out using jdbc under Java?

A datapump that does no transformation takes just a few hours to put
together. If you are simply migrating a schema from one DBMS to
another, this is trivial.

If you want a heftier transformation, you can read the source into a DOM
tree, use XSLT to manipulate the data, and dump the resulting DOM tree
out into the target via JDBC. The code for this required about 1 1/2
days to write and debug.

I push through 6,000,000 rows per hour using this mechanism, with the
limiting factor being how fast the source database can provide data.

On Sat, 2005-04-16 at 16:05 +0200, Martijn Tonies wrote:
>
> > :: Have you czeched out Database Workbench? It has a good data pump.
> >
> > Can it be automated? :)
>
> Database Workbench includes two tools to make this task possible,
> but it cannot be automated. Currently, it's a GUI driven task that
> allows you to convert your schema (datatypes, domains, tables,
> views, indices, constraints) from Firebird to MS SQL Server, the
> other way around etc...
>
> It also has a DataPump to transfer your data.
>
> For quick info, you might want to check:
> http://www.upscene.com/documentation/dbw/tools_schemamigrator.htm
>
> There will be a new version real soon now, that includes several
> bugfixes in this tool as well.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>