I want to export my current database backups from Azure to my local on-premise environment. I have created a .bacpac file from the Azure SQL Database and stored this within my Azure Blob Storage.
However, whenever I download my backup it is always downloaded as a .ZIP file and not a .bacpac file. How can I ensure that I download a .bacpac file?
When you are prompted to save the file locally, simply change the extension from .ZIP to .bacpac.
A .bacpac file is simply a ZIP file (with a .bacpac extension and contains the metadata and data from the SQL Server database).
To export your SQL Database from Azure, navigate to the Azure portal for your SQL Database. You should be able to simply click the 'export' button at the top of the 'Overview' blade.
On the next blade, you will then need to specify
You can then see the progres under "Import/Export" history on the 'Overview' blade towards the bottom.
