I'm currently trying to export attached files from a sql Database taken from a Microsoft Dynamics CRM 2016 application. The attached files data are stored as BLOBs in a VARCHAR(MAX) datatype. Pictures of the database information attached below:
Database Table Contents Picture
So far, none of the sql scripts I've found have worked to extract the files and turn them into regular files. Usually, the scripts will throw the error "String or binary data would be truncated".
My goal is to have the BLOBs taken from the database to just be converted into files.
Is there a way inside of Microsoft Dynamics CRM 2016 to just export the attached files as regular files? Or would it be easier to create a SQL Script to extract them and translate them into regular files?
I eventually used a software tool called SQL Blob Export from YOHS Software that did exactly what I needed. It exported all of the BLOBs into their appropriate file format. SQL Blob Export Site: Sql Blob Export from YOHS Software Link
