MYSQL to other DB migration using MYSQL workbench

According to the MySQL Documentation, the steps for the Migration Wizard should be

1. Connecting to the databases
2. Schemata Retrieval and Selection
3. Reverse Engineering
4. Object Selection
5. Migration
6. Manual Editing
7. Target Creation Options
8. Schema Creation
9. Create Target Results
10. Data Migration Setup
11. Bulk Data Transfer
12. Migration Report

Sounds like you got to Step 9. You have to make sure to setup Data Migration. Apparently, it is not automatic.

If you are having problems with the import, you are not alone. This has been a source of heartache for many. You may need to try :

• MySQL Migration Toolkit
• SQLyog

Like @bauerInHsv said, Oracle has a vested interest in providing minimal support for migrating off of its enterprise offering (Oracle) and onto its open-source RDBMS (MySQL).

As an alternative to MySQL Workbench, you could use etlalchemy.

It is an open-source Python tool, that lets you migrate between any 2 relational database with 4 lines of Python.

To install:

pip install etlalchemy
# On El Capitan:
#### pip install etlalchemy --ignore-installed

To run:

from etlalchemy import ETLAlchemySource, ETLAlchemyTarget

oracle_db_source = ETLAlchemySource("oracle+cx_oracle://username:password@hostname/SID")

mysql_db_target = ETLAlchemyTarget("mysql://username:password@hostname/db_name",
                                       drop_database=True)
mysql_db_target.addSource(oracle_db_source)
mysql_db_target.migrate()

This will handle the migration in the following order:

1. Migrating the Schema
2. Migrating the Data
3. Migrating the Indexes
4. Migration the Constraints

(P.S. I wrote this tool, so feel free to reach out if you find something broken.)