Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\J0039062\AppData\Roaming\MySQL\Workbench\log\wb.log]
0
down vote
favorite
MySQL workbench offers a migration tool that I'm using to migrate an Oracle database to MySQL.
I'm using the migration wizard to migrate the complete Oracle schema to MySQL. I used that for the migration wizard and a RDBMS source thru odbc to connect the oracle source.
Step 1 : Source is configured and tested (RDBMS: Odbc Oracle source)
Step 2 : Destination is configured (mysql)
Step 3 : Introspection is OK
Step 4 : Table list is empty
Table list is empty
Unfortunately, the object list is empty, so I can't get the next step.
A short test of the odbc driver through excel confirmed that the odbc is correctly configured and displays the table list.
mysql workbench 6.3
odbc driver oracle 11.2
java 1.8
Oracle database 10g
Seescreenshot in http://dba.stackexchange.com/questions/114793/migrating-from-oracle-to-mysql-via-mysql-wor...
How to repeat:
Select Database>Migration wizard
Start migration
Database system : GEneric RDBMS
Connection method : Odbc Datasource
DSN : a Oracle ODBC datasource (Oracli112)
Test connection (suceeded)
Next
Mysql Stored Datasource
Test connection : succeeded
Next
Connect to datasource : check
Check target : check
Retrieve schema from source : check
Next
Include / schemata window is empty
Description: ----[For better reports, please attach the log file after submitting. You can find it in C:\Users\J0039062\AppData\Roaming\MySQL\Workbench\log\wb.log] 0 down vote favorite MySQL workbench offers a migration tool that I'm using to migrate an Oracle database to MySQL. I'm using the migration wizard to migrate the complete Oracle schema to MySQL. I used that for the migration wizard and a RDBMS source thru odbc to connect the oracle source. Step 1 : Source is configured and tested (RDBMS: Odbc Oracle source) Step 2 : Destination is configured (mysql) Step 3 : Introspection is OK Step 4 : Table list is empty Table list is empty Unfortunately, the object list is empty, so I can't get the next step. A short test of the odbc driver through excel confirmed that the odbc is correctly configured and displays the table list. mysql workbench 6.3 odbc driver oracle 11.2 java 1.8 Oracle database 10g Seescreenshot in http://dba.stackexchange.com/questions/114793/migrating-from-oracle-to-mysql-via-mysql-wor... How to repeat: Select Database>Migration wizard Start migration Database system : GEneric RDBMS Connection method : Odbc Datasource DSN : a Oracle ODBC datasource (Oracli112) Test connection (suceeded) Next Mysql Stored Datasource Test connection : succeeded Next Connect to datasource : check Check target : check Retrieve schema from source : check Next Include / schemata window is empty