MySQL Forums
Forum List  »  Microsoft SQL Server

Migrating from SQL Server 2008 R2
Posted by: Tamer Ahmed
Date: December 02, 2013 02:29AM

Hi,i'm trying to migrate from SQl Server 2008 R2 but i have this error in the reverse engineer selected schemata

File "C:\Program Files (x86)\MySQL\MySQL Workbench CE 6.0.7\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]The data types nvarchar and text are incompatible in the equal to operator. (402) (SQLExecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (8180)')

and and i'm trying to edit the Data Type mapping but it don't save the modification

note:i'm very new in my sql

Options: ReplyQuote


Subject
Written By
Posted
Migrating from SQL Server 2008 R2
December 02, 2013 02:29AM


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.