Oracle-to-MySQL

Oracle-to-MySQL Oracle-to-MySQL is a program for copying data from Oracle DBMS to MySQL server. Direct connection to the source and target databases allows you to achieve the best performance. Oracle-to-MySQL supports command line parameters to run in batch mode.

Features:

• All versions of Oracle and MySQL are supported;
• No Oracle components are required;
• Fast data processing algorithm: about 20,000 records per second on the Core i7 chipset;
• Possibility to merge Oracle data with the existing MySQL database;
• Ability to synchronize MySQL and Oracle databases;
• Ability to redefine the target table structure;
• Ability to filter data for conversion using SELECT-queries;
• Option to export Oracle data into MySQL dump file;
• Command Line Support;
• Converts indexes with all necessary attributes;
• Converts foreign keys;
• Converts Oracle views to MySQL format;
• Saves conversion settings in a profile;
• Supports Unicode

Limitations:

• Stored procedures and triggers are not converted;
• Fields with non-standard (user-defined) data types cannot be converted;
• The Demo version will not convert more than 50 records per table;
• The demo version does not convert views and relatedness relations between tables