Sql compare bug

DanAvni

i have a live sql 2008 DB with a field declared as nvarchar(max)
i took a snapshot from sql 2005 where the field exists as nvarchar(200) and used sql compare to compare the live db to the snapshot.

sql compare detects the change but when building a sync script i get a warning that

Severity: High
Object: CatalogItems
Title: The type NVarchar(max) on object [dbo].[CatalogItems].[Description] is not supported in the target database version.

although nvarchar(max) is supported on sql 2005

James B

Thanks for your post. I was unable to replicate this myself, so I've opened a support ticket and contacted you directly.