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

VarBinary(max) field difference not being scripted

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
Ivan
0

Comments

2 comments

Sort by
  • 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.
    ipelly
    0
  • 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!
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.