VarBinary(max) field difference not being scripted

ipelly

Hi - I have a record in the source table that's not in the target table, and in the source there's data in a varbinary(max) column. But the difference script just inserts one byte into the varbinary column, not the actual data, e.g.

INSERT INTO [dbo].[BinaryFile] ([ID_BinaryFile], [ID_Lineage], [BinaryFile]) VALUES ('00fc1f35-076d-49fe-82f2-4c75acae5965', '00000000-0000-0000-0000-00000000000a', 0x)

Wondering how to get the actual binary data to the target table. Thanks. Oh, I'm using v.11

ipelly

Forgot to add one (maybe two) critical bits of information to the above: 1) I'm comparing a differential backup to the full backup in the same backup set, and 2) the varbinary(max) column is stored in a FileStream. However, when I compare a backup to a live database, I don't see the issue, i.e. the varbinary(max) column content is included in the script as a long (base64?) string.

Tianjiao_Li

Hi,

Thanks for posting. Can you please confirm the full version number of your SQL Data Compare V11?
Can you please try the latest version and see if it solves your issue? Installer available here: ftp://support.red-gate.com/patches/SQLDataCompare/08Aug2017/

Thanks!