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

varbinary being cutoff at 8000

I'm having issues when creating a script for a table that that has a column varbinary(MAX). Some of the records has datalength over 8000, after running the script created it's cutting off those records at 8000. I can't find any setting or how to avoid this.
gmoore
0

Comments

5 comments

Sort by
  • Chris Auckland
    Thanks for your post.

    Is the column varbinary(max) on both the source and the target table?
    Chris Auckland
    0
  • gmoore
    Yes.

    Thanks
    gmoore
    0
  • Chris Auckland
    Ok, I'll test this out. It sounds like a bug.
    Chris Auckland
    0
  • Chris Auckland
    What version of SQL Data Compare are you using?

    I just tried synchronising a VARBINARY(max) column with 36466 characters, and that migrated ok.

    Would you be able to send me the DDL for both tables, so I can try and recreate the same project?
    Chris Auckland
    0
  • gmoore
    Ok noticed what I did wrong, I modified the key value in the script created but didn't notice it had broken the larger binary rows into blocks of 8000 chars, so the following updates didn't run after the original insert.

    Thanks for help.
    gmoore
    0

Add comment

Please sign in to leave a comment.