Oracle-to-MySQL is a program to migrate Oracle databases to MySQL server.

Features

• All Oracle data types (except BFILE and MLSLABEL) and attributes are supported
• Work with all versions of Unix and Windows MySQL servers
• Command line support
• Convert indexes with all necessary attributes
• Convert foreign keys
• Merge Oracle data into an existing MySQL database
• Convert individual tables
• Exports Oracle databases into MySQL dump file (see below)
• Easy-to-use wizard-style interface
• Full install/uninstall support

Limitations

• Does not convert stored procedures
• Does not convert columns having user-defined types
• Does not allow to connect to Oracle database as SYSDBA or SYSOPER

Requirements

• At least 32 MB RAM
• Oracle client and networking components must be installed on the same machine where you run Oracle-to-MySQL from
• Necessary privileges to write into the destination database

MySQL dump file

Oracle-to-MySQL converter allows users to do indirect conversion and get more control over the process. Following this way, the program converts Oracle data into a local MySQL dump file instead of moving it to MySQL server directly. This dump file contains MySQL statements to create all tables and to fill them with the data. Click here to learn how to import dump file into MySQL database.