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 lik

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

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 commerc