This discussion is archived
3 Replies Latest reply: Apr 24, 2013 5:35 PM by 969772 RSS

MySQL to Oracle

1005172 Newbie
Currently Being Moderated
Hi All,

I'm new here. I have 10GB++ mysql database in production server. My company decided to move to Oracle database. Kindly please help/suggest migration tool which i can use to migrate my database from MySQL to oracle. Thanks in advance.
  • 1. Re: MySQL to Oracle
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    You can use the SQL*Developer migration workbench to move from MySQL to Oracle. It is free to download and use and you can get more information from these sites -

    SQL*Developer -

    http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
    - download, documentation etc.

    Migration -

    http://www.oracle.com/technetwork/database/migration/index-084442.html

    - detailed migration information and examples for each non-Oracle database.

    For a 10gb database it would be better to use an offline migration as this will give you more control over what happens and makes it easier torecover from any errors.
    The default migration is 'online' but this is only intended for very small databases.

    Regards,
    Mike
    Regards,
    Mike
  • 2. Re: MySQL to Oracle
    DmitryTolpeko(SQLines) Newbie
    Currently Being Moderated
    You can also use SQLines Data for MySQL to Oracle: http://www.sqlines.com/sqldata/mysql-to-oracle

    It transfers data in multiple concurrent sessions (MySQL C API and OCI connections) and allows you to validate the migration (comparing row count and data)

    Dmitry
  • 3. Re: MySQL to Oracle
    969772 Newbie
    Currently Being Moderated
    As well, have a look at http://convertdb.com/mysql/oracle . It transfers 1 million records in about 6 min.

Incoming Links

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points