Extract fysical file from sqlserver/db blobfield

we are using a sqlserver db with blob fields. in that field is the content of a fysical file stored. can easymorph extract the file-data to a fysical file?

Hi Paul and welcome to the Community!

I’ll check it with our dev team and will reply as soon as I know the answer.

Hi Paul,

Sorry for the late reply.

The “Import from database” action doesn’t support binary data type.

If you are familiar with PowerShell, you can try to use the following workaround:

  1. Add the below expression to the “Import from database” action. It will make the action to import your binary data as hex strings.

CONVERT(VARCHAR(MAX), [ColumnName], 2)

  1. Use the “PowerShell” action to output imported hex strings as binary files.