I have an ancient version 6.1 database that has a table that contains a BLOB field. The BLOB field is used to store a PDF file. I'd love to use a SQL Query as shown below.
INSERT INTO [Nav90Database].[PDF_Storage_Table] ([TableKeyField], [BlobField])
SELECT [TableKeyField], [BlobField] FROM [NAV61Database].[PDF_Storage_Table].
However when I transfer the data using the SQL query and issue a CALCFIELDS in NAV 2016, I get the message "The PDF_Storage_Table contains a BLOB field with compression data that is not valid".
It seems that I have to do some sort of SQL .net voodoo to get these PDF files across the great divide. I've searched the forum without any luck. Any suggestions?
Pacific City, OR