Migrate IBM DB2 (9.7) to MSQL

[andreas Balg]

Is there a Bug in our ODBC-SOurce Setup or in MySQL Workbench - How may I do a simple 1:1 (no views, triggers, stored procedures) DB2 to MySQL:

Workbench (5.2.42 CE) just tells Me the fllwing while trying to reverse engineer the DB:

Opening ODBC connection to DSN=gruppeodb;PWD=XXXX...

Connected

Reverse engineering GRUPPE from None

- Reverse engineering catalog information

- Preparing...

- Gathered stats for GRUPPE

*** WARNING: The schema GRUPPE was not found in the catalog None. Skipping it.

Traceback (most recent call last):

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\db_generic_re_grt.py", line 281, in reverseEngineer

total_tables = sum(table_count_per_schema[schema.name] for schema in catalog.schemata)

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\db_generic_re_grt.py", line 281, in <genexpr>

total_tables = sum(table_count_per_schema[schema.name] for schema in catalog.schemata)

KeyError: ''



Traceback (most recent call last):

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\workbench\wizard_progress_page_widget.py", line 191, in thread_work

self.func()

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\migration_schema_selection.py", line 160, in task_reveng

self.main.plan.migrationSource.reverseEngineer()

File "C:\Users\aba\Downloads\MySQL Workbench 5.2.42 CE\modules\migration.py", line 329, in reverseEngineer

self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)

SystemError: KeyError("('',)"): error calling Python module function DbGenericRE.reverseEngineer

*** ERROR: Reverse engineer selected schemata: KeyError("('',)"): error calling Python module function DbGenericRE.reverseEngineer

Failed