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 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]


ORACLE to MySQL migration

2004-03-16 Thread Enrico . Venturi
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]


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 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]
 


__
Do you Yahoo!?
Yahoo! Mail - More reliable, more storage, less spam
http://mail.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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 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/mysql? [EMAIL PROTECTED]
 
 
 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]