Hi,

I used to use DTS for transferring data between Informix and SQL Server
and it worked very nicely. I now need to replicate data between Oracle
and MySQL and need a similar tool. I can't use DTS because I no longer
have SQL Server, and I can't use Oracle or MySQL's replication service,
because they only work between 2 Oracle or 2 MySQL databases.

I don't need anything particularly sophisticated, just something which
can copy data between an Oracle and MySQL database, and ideally is
available free-of-charge.

Thanks in advance,
Don

If you have the drivers then you could write something yourself in a
language such as C#

What about deriving something through Access (although not technically free
of charge)

Does Oracle not have any ETL Modules you can use or does everyone use
Informatica?

--


Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com



<donalmurtagh (AT) yahoo (DOT) co.uk> wrote

Do you need online replication or periodic data transfers?

wisdomforce fastreader works pretty fast for oracle data transfer both
into MySQL or SQL Server. It does not even requires target to be online
and creates loader script. Alternatively FastReader can write data
into pipe in ASCII format that can be readed to load into target.

fastreader is not free though: www.wisdomforce.com


donalmurtagh (AT) yahoo (DOT) co.uk wrote: