Hi,
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!
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!