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