DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How can I export from Oracle to .mysql format

  1. #1
    Join Date
    Mar 2014
    Posts
    1

    Question How can I export from Oracle to .mysql format

    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!

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

  3. #3
    Join Date
    Mar 2014
    Posts
    1
    You can also use OraDump-to-MySQL program for the same.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width