How can we help you today? How can we help you today?

Custom Comparison Key

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.
VSinha
0

Comments

2 comments

Sort by
  • 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.)
    Jessica R
    0
  • VSinha
    Thanks Jessica
    VSinha
    0

Add comment

Please sign in to leave a comment.