Re: Migrate from .accdb to MySQL

[Paolo Ermini]

Thanks for answer ;)

In fact I'm using Microsoft SQL Server... now it works ;)

But now I have a new problem :(
During "Reverse engineer Source" step, I have this log:



Starting...

Connect to source DBMS...

- Connecting...

Connecting to ...

Opening ODBC connection to DSN=DATI_2...

Connected

Connect to source DBMS done

Reverse engineer selected schemata....

Reverse engineering accdb.None from C:\DATI

- Reverse engineering catalog information

- Preparing...

Traceback (most recent call last):

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 683, in reverseEngineer

return GenericReverseEngineering.reverseEngineer(connection, catalog_name, schemata_list, context)

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 228, in reverseEngineer

table_count_per_schema[schema_name] = len(cls.getTableNames(connection, catalog_name, schema_name)) if get_tables else 0

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_generic_re_grt.py", line 176, in getTableNames

cls.get_connection(connection).cursor().tables(catalog=catalog_name, schema=schema_name) if row.table_type=='TABLE'))

pyodbc.Error: ('HYC00', '[HYC00] [Microsoft][Driver ODBC Microsoft Access]Caratteristica opzionale non implementata (106) (SQLTables)')



Traceback (most recent call last):

File "C:\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 191, in thread_work

self.func()

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\migration_schema_selection.py", line 160, in task_reveng

self.main.plan.migrationSource.reverseEngineer()

File "C:\MySQL\MySQL Workbench 5.2 CE\modules\migration.py", line 332, in reverseEngineer

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

SystemError: Error("('HYC00', '[HYC00] [Microsoft][Driver ODBC Microsoft Access]Caratteristica opzionale non implementata (106) (SQLTables)')"): error calling Python module function DbGenericRE.reverseEngineer

ERROR: Reverse engineer selected schemata: Error("('HYC00', '[HYC00] [Microsoft][Driver ODBC Microsoft Access]Caratteristica opzionale non implementata (106) (SQLTables)')"): error calling Python module function DbGenericRE.reverseEngineer

Failed



do you have any good hint for me?
Thanks ;)