Data migration error (Reverse engineering process)
I am geeting error when iporting the ms sql server 2005 data in mysql.
The error is :
tarting...
Connect to source DBMS...
- Connecting...
Connect to source DBMS done
Reverse engineer selected schemata....
Reverse engineering dbo, VSM from VSM
- Reverse engineering catalog information
- Reverse engineering User Data Types...
- Preparing...
- Gathered stats for dbo
- Gathered stats for VSM
Reverse engineering 145 tables from dbo
- Retrieving table dbo.Delhi_client20a...
- Retrieving table dbo.gridih_associates_15march...
- Retrieving table dbo.Delhi_client20ab...
- Retrieving table dbo.associate2b...
- Retrieving table dbo.gridih_associates_15marcha...
- Retrieving table dbo.gridihtrust_15march...
- Retrieving table dbo.gridihtrust_15marcha...
- Retrieving table dbo.Associate2...
- Retrieving table dbo.DELHI_MEMBER20a...
- Retrieving table dbo.gridih_ltd_15marcha...
- Retrieving table dbo.Gridih19march_assco...
- Retrieving table dbo.Delhi_associate20a...
- Retrieving table dbo.RATES...
- Retrieving table dbo.Relation...
- Retrieving table dbo.Gridih19march_trust...
- Retrieving table dbo.Delhi_associate20ab...
- Retrieving table dbo.Delhi_client20abc...
- Retrieving table dbo.Delhi_member_19abcd...
- Retrieving table dbo.branch1...
- Retrieving table dbo.'TRUST CUSTOMER$'...
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 384, in reverseEngineer
reverseEngineerTables(connection, schema)
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 557, in reverseEngineerTables
reverseEngineerTablePK(connection, table)
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 687, in reverseEngineerTablePK
pk_col_names = [ row[3] for row in execute_query(connection, query) ]
File "C:\Program Files\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: ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'TRUST'. (102) (SQLExecDirectW)")
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "C:\Program Files\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\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("('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'TRUST'. (102) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.reverseEngineer
ERROR: Reverse engineer selected schemata: ProgrammingError("('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'TRUST'. (102) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.reverseEngineer
Failed
Could anyone help.