Convert varbinary(max) column from Azure SQL database into local image file

Question

We have an Azure SQL database with a table which contains a number of images in a varbinary(max) column. I would like to be able to extract these to image files to be stored locally.

I have found various posts and code snippets for doing this from a SQL Server database, but they all involve running sp_configure to change the permissions for 'show advanced options' and 'OLE automation procedures' which don't apply to Azure SQL.

Is there a way of doing this from Azure?

Many thanks! Jim

Answer 1

I see the problem. I brief list of solutions:

1. Use SSIS or ADF.
2. Export the Azure SQL Database from Azure to a SQL Server On Prem, use sp_configure, and then delete the varbinary(max) column that contains the images on Azure.