Migrating from SQL Server 2008 R2
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
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.