Database specialists who intend to migrate databases from Oracle to MySQL or backward
should consider all benefits and disadvantages of each DBMS before they start. This article
gives an integral picture of cons and pros for Oracle and MySQL.
- Sophisticated security system. Unlike MySQL, Oracle supports groups or roles.
There is ability to deny a privilege in Oracle, while MySQL only allows to grant.
- External authentication options like LDAP, Active Directory. MySQL supports
only built-in authentication.
- True full-text search. In MySQL this feature is limited and only available
for non-transactional storages.
- Sophisticated administration tools and IDEs for debugging.
- Integration with business intelligence applications.
- High price. The Oracle product can cost multiple times as much as comparable
- Complexity. Unlike MySQL, Oracle requires deep skills to install and maintain
it due to complex engine.
- It's open source.
- Low Total Cost of Ownership. The price of MySQL commercial licenses is less
expensive than same configuration of Oracle. Also, MySQL has less demands to
the hardware platform compared to Oracle.
- Each table can have a different storage engine.
- Each storage engine has particular behavior, features, and properties.
- Does not support user-defined types.
- Does not support fractional part of seconds for time and datetime types.
- There are no recursive queries.
- Does not support functional columns that are calculated as expression.
- "ALTER TABLE" or "CREATE TABLE" statements are non-transactional.
- Does not support materialized views.
- Does not support sequences.
- Does not support roll-back recovery, only roll-forward is supported.
- Foreign keys are not supported in most storage engines.
If database migration is confirmed after all considerations, it is reasonable
to look for dedicated software products for automating the migration process.
Intelligent Converters offer two products to convert Oracle to MySQL
and MySQL to Oracle handling all database objects except
stored procedures and triggers.