Sql compare bug

DanAvniDanAvni Posts: 65 Bronze 2
edited October 27, 2010 9:48AM in SQL Compare Previous Versions
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
Dan Avni


Sign In or Register to comment.