SQL Insider Series: Exporting Azure SQL DB BACPAC file to Azure with Azure Automation | Data Exposed
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.
0:00 Introduction
1:20 Scenario
2:13 Demo
10:07 Getting started
✔️ Resources:
Azure Automation documentation: https://docs.microsoft.com/en-us/azur...
Export a database to a BACPAC file - Azure SQL Database & Azure SQL Managed Instance: https://docs.microsoft.com/en-us/azur...
📝 SQL Insider Series Playlist: https://aka.ms/sqlinsiderseries
📌 Let's connect:
Twitter: Mike Bhatt, / bhattman7
Twitter: Anna Hoffman, / analyticanna
Twitter: AzureSQL, https://aka.ms/azuresqltw
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt
#AzureSQL #AzureSQLDB #SQLServer #AzureAutomation #SQLInsiderSeries
