There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Operand type clash: image is incompatible with geography
I have SQL 2008 Express R2 SP1 using SQLAzureMW v3.8.2.
When running the migration the code is generated fine, but when I execute the script against the SQL Azure server I get the error:
SQLState = 22005, NativeError = 206
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Operand type clash: image is incompatible with geography
BCP copy in failed
I have checked my DB is in Compatibility_Level 100, I have also checked the generated code shows the field as Geography not Image.
Anyone else had this problem and know a work around?