firebird to mysql using workbench
Trying to migrate form Firebird to MySql using Workbench 6.1 on a XP box.
FireBird ODBC = Firebird/Interbase() version 2.00.02.153
MySql ODBC = MySql ODBC 5.1 Driver version 5.01.8.00
Wuen testing connection, on Windows ODBC Administrator, both connect with sucsses.
At MySql Workbench Migration Wizard:
Source RDMS Connection Parameters
System Database : Generic RDBMS
COnnection Method : ODBC Data Sourc
DNS: points to firebird ODBC
user SYSDBS passwd masterky (defined at ODBC Administrator level)
If conecction is tested it comes out ok again
Traget RDMS Parameters
Stored connection : Local Instance MySql
Connection Method : Standard (TCP/IP)
Hostname: Localhost
Port : 3306
Username : root
If conecction is tested it turns out ok
If I start the migration clicking next software goes to Fetch Schema List screen
On this screen both connect to Source RDMS and Target RDMS check as ok
Retrive schema list from source check as NOT OK
Follows log msg:
Starting...
Connect to source DBMS...
- Connecting to source...
Connecting to ...
Opening ODBC connection to DSN=firebirdodbc...
Connected
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
Connection to apparently lost, reconnecting...
Connecting to ...
Opening ODBC connection to DSN=firebirdodbc...
Connected
- Fetching catalog names...
- Fetching schema names...
- Fetching schema names from
Traceback (most recent call last):
File "C:\Arquivos de programas\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_re_grt.py", line 719, in getSchemaNames
return GenericReverseEngineering.getSchemaNames(connection, catalog_name)
File "C:\Arquivos de programas\MySQL\MySQL Workbench 6.1 CE\modules\db_generic_re_grt.py", line 200, in getSchemaNames
return list(set(row[1] for row in cls.get_connection(connection).cursor().tables(catalog=catalog_name)))
TypeError: argument 2 must be string without null bytes, not str
Traceback (most recent call last):
File "C:\Arquivos de programas\MySQL\MySQL Workbench 6.1 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Arquivos de programas\MySQL\MySQL Workbench 6.1 CE\modules\migration_source_selection.py", line 439, in task_fetch_schemata
self.main.plan.migrationSource.doFetchSchemaNames(only_these_catalogs)
File "C:\Arquivos de programas\MySQL\MySQL Workbench 6.1 CE\modules\migration.py", line 253, in doFetchSchemaNames
schema_names = self.getSchemaNames(catalog)
File "C:\Arquivos de programas\MySQL\MySQL Workbench 6.1 CE\modules\migration.py", line 208, in getSchemaNames
return self._rev_eng_module.getSchemaNames(self.connection, catalog or '')
SystemError: TypeError("argument 2 must be string without null bytes, not str"): error calling Python module function DbGenericRE.getSchemaNames
ERROR: Retrieve schema list from source: TypeError("argument 2 must be string without null bytes, not str"): error calling Python module function DbGenericRE.getSchemaNames
Failed
Any help is weelcome as I'm in a tight spot
Best regards