Hi everyone,
I am currently moving our access database over to SQL. I have used the "SQL server migration assistant for access" and it seems to have worked well apart from our Documents table.
It has converted the OLE Object access data type into a varbinary(max) and now the documents won't open when we try to access them via our new C# based code.
I have been searching for a few days, so if anyone has any pointers for how to correctly convert this varbinary(max) into a usable file format, it would be helpful.
Just to note, the end goal for migration is to convert these into OLE Object files and store them all in blob storage.
Thanks,
Jack
I am currently moving our access database over to SQL. I have used the "SQL server migration assistant for access" and it seems to have worked well apart from our Documents table.
It has converted the OLE Object access data type into a varbinary(max) and now the documents won't open when we try to access them via our new C# based code.
I have been searching for a few days, so if anyone has any pointers for how to correctly convert this varbinary(max) into a usable file format, it would be helpful.
Just to note, the end goal for migration is to convert these into OLE Object files and store them all in blob storage.
Thanks,
Jack