What are the challenges you face when working across database platforms? Take the survey

Custom Comparison Key

VSinhaVSinha Posts: 10 New member
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.


  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    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 Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?

  • Options
    VSinhaVSinha Posts: 10 New member
    Thanks Jessica
Sign In or Register to comment.