RE: ORACLE to MySQL migration

2004-03-17 Thread DChristensen
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

Re: ORACLE to MySQL migration

2004-03-16 Thread Karam Chand
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 commercial

RE: ORACLE to MySQL migration

2004-03-16 Thread Weaver, Walt
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 MySQL