Skip to main content

All Questions

0 votes
1 answer
2k views

How to use Azure Data Factory to restore an Azure SQL Database from Azure Blob Storage

I have a vendor who dumps a .bak of our database to their SFTP server each night. I'm using ADF to copy that file each day to Azure Blob Storage. I'd like to be able to restore that database from the ...
buktseat's user avatar
0 votes
1 answer
293 views

how to set bulk_options in openrowset to read PDF files from Azure blob storage?

I have an Azure SQL managed instance and would like to read pdf files(images) from Azure blob storage with openrowset. I'm able to read single file when I specify pdf file names but to read multiple ...
user112359's user avatar