Is it really necessary to migrate to MySQL?

There is no universal answer to this question. Migrating Oracle database to MySQL server brings multiple benefits: low TCO (total cost of ownership), large community of MySQL database professionals, open source, tight integration with web and much more. However, for complex corporate-scale data warehouses it is reasonable to stay with Oracle since it provides rich compatibilities and wide range of tools for this purpose.

Procedure of Oracle to MySQL migration

The process of database migration from Oracle to PostgreSQL consists of the following stages:

  • exporting Oracle tables into DDL (data definition language) statements
  • translating that DDL-statements according to MySQL format and loading to the target server
  • exporting Oracle data into temporary CSV (comma separated values) storage
  • modifying CSV files according to MySQL format if it is necessary and importing into target database
  • exporting Oracle triggers, views, stored procedures and functions into SQL statements and source code
  • translating these statements and code according to MySQL syntax and loading it to the target database

This brief guide indicates that Oracle to MySQL migration is a complicated process, especially for large databases containing complex logic such as triggers, stored procedures and functions. Doing migration manually may cause some errors or data integrity loss due to human factor. That’s why many database specialists use special tools designed to simplify and automate migration procedure.

Oracle to MySQL migration tool

One of such database migration tools is Oracle-to-MySQL developers by Intelligent Converters, software company that is specialized in database conversion and synchronization since 2001. The program supports all versions of Oracle and MySQL running on Linux/Unix/Windows platforms, including such variations as MariaDB, Percona and cloud based solutions. Oracle-to-MySQL migrates the following database objects with all necessary properties and attributes:

  • Table definitions
  • Data
  • Indexes and constraints
  • Foreign keys
  • Views

The tool also provides command line support in order to automate database migration. Option to convert Oracle data into MySQL script instead of moving to the target server directly may help in those situations when direct connection to MySQL server is not available. Other valuable features of Oracle-to-MySQL converter:

  • High performance migration engine – more than 20,000 records per second on an average modern system
  • Option to synchronize MySQL database with Oracle data (only insert and update sync is available)
  • Option to filter data for conversion using SELECT-queries
  • Option to customize structure of destination table
  • Full Unicode support
  • Conversion settings can be stored into profile for next runs
  • Intuitive wizard-style interface and full install/uninstall support

Views: 80


You need to be a member of The Future of Education to add comments!

Join The Future of Education

A Learning Revolution Project

Education Quotes & Commentary

Twitter Feed

© 2018   Created by Steve Hargadon.   Powered by

Badges  |  Report an Issue  |  Terms of Service