MySQL Forums
Forum List  »  MySQL Workbench

firebird to mysql using workbench
Posted by: Stelio Pizzolatto
Date: April 03, 2014 11:45AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
firebird to mysql using workbench
11796
April 03, 2014 11:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.