Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    9

    Unanswered: How to move a DB (with data content) from Oracle to MySQL (or vice versa)?

    Assume I have an existing DB in Oracle.
    Nothing extraordinary: Some tables with some foreign key references and some data rows.

    What is the easiest way to retrieve the table+index definitions and the data rows from Oracle and create them and insert them into a MySQL DB?

    Possibly there is a comfortable 3rd party tool available?

    Thank you
    Peter

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    530
    No easy way.

    For a huge number of data, use any tool like Sybase PowerDesignor to reverse and "translate" your Oracle model to mysql.

    Then use any pipe program to pass the data from Oracle to Mysql (MS-Access, MS-SQL )
    For a small number of huge tables you can use Oracle external tables to export your tables and mysql csv engine to recover them.
    F. Celaia
    DBA Oracle/MS-SQL/MySQLSybase/DB2/

Posting Permissions

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