Oracle and MySQL are both extremely popular modern database management systems. When planning migration from Oracle to MySQL or backward, it is vital to recognize all cons and pros of each DBMS before beginning the process. This white paper explores the most important strong and weak sides of Oracle and MySQL.
Benefits of Oracle:
- Mechanism of advanced authentication like LDAP and Active Directory. MySQL provides only option of built-in authentication.
- Flexible security system. Unlike MySQL, Oracle has such security features as groups and roles. Also Oracle allows to deny a privilege, while MySQL provides only grant option.
- Object oriented features. MySQL does not support it at all.
- Integration with business intelligence applications.
- High price. The Oracle software costs much more than appropriate edition or license of MySQL.
- Complexity. Oracle requires higher experience of database specialists than MySQL due to highly complicated DBMS engine.
- The primary benefit of MySQL is that it’s open source.
- Low Total Cost of Ownership. MySQL commercial licenses cost less than same configuration of Oracle. The same is applied to development and administration tools.
- Every table can have its own storage engine with corresponding features.
- Each storage engine has particular behavior, features, and properties that gives more overall flexibility to the database.
- MySQL does not support user-defined types.
- It Does not support functional columns that are calculated as expression.
- MySQL does not support materialized views.
- There are no sequences in MySQL, however some kind of related capabilities may be implemented via auto_increment.
If an organization still needs database migration between Oracle and MySQL, it is reasonable to use special software for this purpose. Manual migration for such advanced DBMS may cause data loss or corruption due to human factor. Intelligent Converters, software company specializing in database migration since 2001, offers two products to migrate from Oracle to MySQL and backward. Both products support all entries of the database except stored procedures and triggers. Also, command line is supported to automate, script and schedule the migration process.
<< STOPPED HERE >>
Other features of those tools:
- All versions of MySQL and Oracle running on Linux/Unix and Windows platforms are supported
- Table definitions, data, indexes, constraints and views are converted with all necessary attributes
- Source data can be merged or synchronized with existing destination tables
- Option to customize resulting table structure (name, type and other attributes of every column can be modified)
- Option to filter data for migration using SELECT-queries
- All conversion properties can be stored for next run