0

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

BiigJiim
  • 165
  • 1
  • 1
  • 10

1 Answers1

0

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.
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
  • Thanks Francesco. I am not sure we will have a local SQL Server available, so I might have to look at getting SSIS implemented. Is this the only other option? No way of doing this directly from the Azure SQL db? – BiigJiim May 03 '23 at 09:05
  • Install SQL Server Developer edition on your laptop and do it there – Francesco Mantovani May 03 '23 at 11:51