MySQL Forums
Forum List  »  Microsoft Access

Workbench Access migration issue
Posted by: Jean-Baptiste QUEROMES
Date: November 26, 2015 02:02AM

Hello

Workbench 6.3.5 build 201 , MS windows 7 service pack 1 and MS access 2013.

I'm trying to migrate a data base I've created on access2013 to mysql with workbench migration tool.

Everything is going fine until the step "reverse engineer source", where process stops at the step "reverse engineering selected schemas".

I don't know what I have to do to fix the problem, maybe changing charset in the "source selection" step, but with which charset ?

Here is the log :

Starting...
Connect to source DBMS...
- Connecting...
Connecting to ...
Opening ODBC connection to DSN=mpd_site_web...
Connected
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering Base de données2 from def
- Reverse engineering catalog information
- Preparing...
- Gathered stats for Base de données2
Reverse engineering tables from Base de données2
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_re_grt.py", line 751, in reverseEngineer
return MsAccessReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_re_grt.py", line 291, in reverseEngineer
cls.reverseEngineerTables(connection, schema)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\db_msaccess_re_grt.py", line 420, in reverseEngineerTables
grt.send_progress(i / total, 'Retrieving table %s.%s...' % (schema.name, table_name))
UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 29: ordinal not in range(128)

Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\migration_schema_selection.py", line 175, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\modules\migration.py", line 369, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: UnicodeDecodeError("'ascii' codec can't decode byte 0xc3 in position 29: ordinal not in range(128)"): error calling Python module function DbMsAccessRE.reverseEngineer
ERROR: Reverse engineer selected schemas: UnicodeDecodeError("'ascii' codec can't decode byte 0xc3 in position 29: ordinal not in range(128)"): error calling Python module function DbMsAccessRE.reverseEngineer
Failed

Options: ReplyQuote


Subject
Views
Written By
Posted
Workbench Access migration issue
3645
November 26, 2015 02:02AM
1558
November 26, 2015 02:18AM


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.