Reverse Engineer Access database in MySQL Workbench
I am trying to migrate a Microsoft Access database in MySQL Workbench in Windows 7. The problem is at Revers Engineer Source. I get a "A task has failed executing."
Here is the following message log (I'm new to MySQL, so I don't know what to do next, is there a tutorial out there or a message board I could go to for directions on what to do next?).
Starting...
Connect to source DBMS...
- Connecting...
Connecting to ...
Opening ODBC connection to DSN=OR_MIG...
Connected
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering OR from def
- Reverse engineering catalog information
- Preparing...
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 748, in reverseEngineer
return MsAccessReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 265, in reverseEngineer
routine_count_per_schema[schema_name] = len(cls.getProcedureNames(connection, catalog_name, schema_name)) + len(cls.getFunctionNames(connection, catalog_name, schema_name)) if get_routines else 0
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\modules\db_msaccess_re_grt.py", line 227, in getProcedureNames
cls.get_connection(connection).cursor().procedures() ))
pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 6.2 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.2 CE\modules\migration.py", line 356, in reverseEngineer
self.state.sourceCatalog = self._rev_eng_module.reverseEngineer(self.connection, self.selectedCatalogName, self.selectedSchemataNames, self.state.applicationData)
SystemError: ProgrammingError("('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")"): error calling Python module function DbMsAccessRE.reverseEngineer
ERROR: Reverse engineer selected schemas: ProgrammingError("('42000', "[42000] [Microsoft][ODBC Microsoft Access Driver] Undefined function '|' in expression. (-3102) (SQLProcedures)")"): error calling Python module function DbMsAccessRE.reverseEngineer
Failed