You have a number of options, but to name a couple you could:
.. Use a tool called DBScriptor to export schema/data out of Oracle
and with a few tweaks
it can generate MySQL DDL/insert statements.
.. Use an ODBC "pump" tool like those included with the Borland
tools lik
Perl/DBI is a possibility.
--Walt
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 16, 2004 8:48 AM
> To: [EMAIL PROTECTED]
> Subject: ORACLE to MySQL migration
>
>
> Hello colleagues,
> I have to migrate a lot of ORACLE 8.1.7 databases to
Try SQLyog - http://www.webyog.com/sqlyog
Karam
--- [EMAIL PROTECTED] wrote:
> Hello colleagues,
> I have to migrate a lot of ORACLE 8.1.7 databases to
> MySQL 3.23
>
> I'm looking for a tool or for an algorithm which
> fully supports any
> ORACLE structures ...
> If needed I may use a commerc