Copy .bak file into SQL Server running on Azure VM via ADf

Question

I have a requirement where a third party sends a copy of their database as a .bak file daily. What is the best way to update my SQL server database with this .bak file using Azure Data Factory?

Answer 1

Hi @Sam Bera ,

ADF doesn't support .bak file, your normal SQL Server backup cannot be restored in Azure. There are the Supported file formats

But, you can chooes to restore .bak file to the local server, and then to create a .bacpac file from the restored DB
Then Import a BACPAC file to a database in Azure SQL Database or Azure SQL Managed Instance

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Other option is to copy the backup file to Azure Blob Storage, then you can restore the BAK from that location.
See SQL Server Backup and Restore with Azure Blob Storage