Sync entire row based on couple compared columns

diesel7633diesel7633 Posts: 5 New member

I have a table that contains binary files held in a varbinary field. For performance reasons, I created a CLR function that will create a persisted SHA1 hash of the file in a calculated column (DataSHA1).

I would like to be able to use the ID, Name, and DataSHA1 columns on the table for comparison to determine whether to sync the whole row over. I seem to only be able to sync the columns I'm saying I want to compare rather than all based on that custom compare criteria.

Could someone tell me if I'm missing how to set this up or if there is a reason why this isn't part of the tool? Am I going to have to use the SQL Data Compare SDK? Any help would be appreciated.

Thanks in advance!


Sign In or Register to comment.