Data migration error (Reverse engineering process)
Posted by: anjum jamal
Date: April 25, 2013 06:15AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Data migration error (Reverse engineering process)
April 25, 2013 06:15AM


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.