This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .
Our customers have expressed the need to export Azure SQL database for archiving or importing to on-premise SQL Server for making and testing changes. In this episode of Data Exposed: SQL Insider Series, Mike Bhatt and Anna Hoffman take a look at leveraging Azure automation for exporting to a BACPAC file which can be stored in Azure blob storage or in local storage on premise-location.
Resources:
Azure Automation documentation
Export a database to a BACPAC file - Azure SQL Database & Azure SQL Managed Instance