Description:
When I migrate Azure MSSQL DB to MySQL, an error appeared. It claimed that missing sys.extended_properties.
Starting...
Connect to source DBMS...
- Connecting...
Connecting to Mssql@CPHK_Dev...
Opening ODBC connection to DSN=XXXXXX;DATABASE=XXXXXXX;UID=XXXXXXX;PWD=XXXX...
Connected
Connect to source DBMS done
Reverse engineer selected schemata....
Reverse engineering dbo from XXXXXXX
- Reverse engineering catalog information
- Reverse engineering User Data Types...
- Preparing...
- Gathered stats for dbo
Reverse engineering 135 tables from dbo
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 385, in reverseEngineer
reverseEngineerTables(connection, schema)
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 546, in reverseEngineerTables
table_names = [(row[0], row[1]) for row in execute_query(connection, query % schema.name) ]
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 62, in execute_query
return get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.extended_properties'. (208) (SQLExecDirectW)")
Traceback (most recent call last):
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\migration_schema_selection.py", line 160, in task_reveng
self.main.plan.migrationSource.reverseEngineer()
File "C:\Program Files (x86)\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: ProgrammingError("('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.extended_properties'. (208) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.reverseEngineer
ERROR: Reverse engineer selected schemata: ProgrammingError("('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.extended_properties'. (208) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.reverseEngineer
Failed
How to repeat:
Migrate MSSQL Azuure DB to MySQL thru MySQL Workbench
Description: When I migrate Azure MSSQL DB to MySQL, an error appeared. It claimed that missing sys.extended_properties. Starting... Connect to source DBMS... - Connecting... Connecting to Mssql@CPHK_Dev... Opening ODBC connection to DSN=XXXXXX;DATABASE=XXXXXXX;UID=XXXXXXX;PWD=XXXX... Connected Connect to source DBMS done Reverse engineer selected schemata.... Reverse engineering dbo from XXXXXXX - Reverse engineering catalog information - Reverse engineering User Data Types... - Preparing... - Gathered stats for dbo Reverse engineering 135 tables from dbo Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 385, in reverseEngineer reverseEngineerTables(connection, schema) File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 546, in reverseEngineerTables table_names = [(row[0], row[1]) for row in execute_query(connection, query % schema.name) ] File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 62, in execute_query return get_connection(connection_object).cursor().execute(query, *args, **kwargs) pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.extended_properties'. (208) (SQLExecDirectW)") Traceback (most recent call last): File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work self.func() File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\migration_schema_selection.py", line 160, in task_reveng self.main.plan.migrationSource.reverseEngineer() File "C:\Program Files (x86)\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: ProgrammingError("('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.extended_properties'. (208) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.reverseEngineer ERROR: Reverse engineer selected schemata: ProgrammingError("('42S02', "[42S02] [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.extended_properties'. (208) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.reverseEngineer Failed How to repeat: Migrate MSSQL Azuure DB to MySQL thru MySQL Workbench