Custom Comparison Key

VSinha

During Data deployment using Data Compare tool how can we deploy data to target database which has only one column with datatype nvarchar(max) because we could not find any way to set custom comparison key for columns with nvarchar(max) datatype.

Jessica R

Hi @VSinha,

We need to be able to sort the tables based on a comparison key before running the compare, but as nvarchar(max) cannot be set as a comparison key, I'm afraid it is not possible to compare this table.

(A comparison key cannot include columns whose data type is image, ntext, nvarchar(max), sql_variant, text, varbinary(max), varchar(max), or xml.)

VSinha

Thanks Jessica