varbinary being cutoff at 8000

gmoore

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.

Chris Auckland

Thanks for your post.

Is the column varbinary(max) on both the source and the target table?

gmoore

Yes.

Thanks

Chris Auckland

Ok, I'll test this out. It sounds like a bug.

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?

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.