MySQL Forums
Forum List  »  Oracle

Re: newbie oracle import question
Posted by: Josh Chamas
Date: December 26, 2004 08:46PM

thiruvenkadesh someswaran wrote:
> we are in the process of micrating from oracle to
> mysql. Is there an easy way to do this? like where
> i can feed an application an oracle.exp file and
> gives me a mysql file.dmp file?

Like the prior posted suggested, you can use a tool for this or roll your own using database connectivity like DBI or JDBC. Another tool you might try, which I have not used BTW, is:

http://www.convert-in.com/sql2ora.htm

Generally, I do not think you are going to get an Oracle dump file converted into a MySQL dump file, but will need to move data from Oracle to MySQL directly.

Regards,

Josh

Josh Chamas
Director, Professional Services
MySQL Inc., www.mysql.com
Get More with MySQL! http://www.mysql.com/consulting

Options: ReplyQuote


Subject
Views
Written By
Posted
3063
December 21, 2004 11:05PM
Re: newbie oracle import question
2514
December 26, 2004 08:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.