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
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