How can I export from Oracle to .mysql format

[Rusty]

Hello,

I am new (1st year) in learning to be an Oracle DBA. We have a customer that is requiring us to produce a database based on their description document to support their database model. They require that we deliver the database in .mysql format.

Is there anyway to produce the .mysql format directly from Oracle? I am running an Oracle EE 11gR2 Database.

Thank you for your assistance!

[gandolf989]

You need to create an entity relationship diagram (ERD) from the Oracle database first. If you download and use a trial version of ERwin Studio, you can reverse engineer the Oracle database, and ERwin Studio will help you to convert the schema to MYSQL. Then you just need to create a database link from either the Oracle database or the MYSQL database to the other database and copy the data across. You probably want to create the schema without constraints or indexes first, move the data, then add the missing constraints and data. you will likely need several attempts at this fixing things as you go.

[Kim Thomas]

You can also use OraDump-to-MySQL program for the same.