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 like Delphi, or like the EMS DataPump tool. Have fun! :-) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 9: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 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 commercial tool, otherwise a free software / shared software should be very appreciated Can anyone give me some suggestions? thanks a lot Enrico -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]