SQL Insider Series: Exporting Azure SQL DB BACPAC file to Azure with Azure Automation | Data Exposed

Published Jun 02 2022 09:00 AM 599 Views
Microsoft

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.

 

Watch on Data Exposed

 

Resources:

Azure Automation documentation

Export a database to a BACPAC file - Azure SQL Database & Azure SQL Managed Instance

 

View/share our latest episodes on Microsoft Docs and YouTube!

%3CLINGO-SUB%20id%3D%22lingo-sub-3457741%22%20slang%3D%22en-US%22%3ESQL%20Insider%20Series%3A%20Exporting%20Azure%20SQL%20DB%20BACPAC%20file%20to%20Azure%20with%20Azure%20Automation%20%7C%20Data%20Exposed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3457741%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EOur%20customers%20have%20expressed%20the%20need%20to%20export%20Azure%20SQL%20database%20for%20archiving%20or%20importing%20to%20on-premise%20SQL%20Server%20for%20making%20and%20testing%20changes.%20In%20this%20episode%20of%20Data%20Exposed%3A%20SQL%20Insider%20Series%2C%20Mike%20Bhatt%20and%20Anna%20Hoffman%20take%20a%20look%20at%20leveraging%20Azure%20automation%20for%20exporting%20to%20a%20BACPAC%20file%20which%20can%20be%20stored%20in%20Azure%20blob%20storage%20or%20in%20local%20storage%20on%20premise-location.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CFONT%20size%3D%225%22%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FjZu6n5xUw5A%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWatch%20on%20Data%20Exposed%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3E%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3EResources%3A%3C%2FSPAN%3E%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fautomation%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3EAzure%20Automation%20documentation%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-sql%2Fdatabase%2Fdatabase-export%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CSPAN%3EExport%20a%20database%20to%20a%20BACPAC%20file%20-%20Azure%20SQL%20Database%20%26amp%3B%20Azure%20SQL%20Managed%20Instance%3C%2FSPAN%3E%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EView%2Fshare%20our%20latest%26nbsp%3Bepisodes%20on%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fchannel9.msdn.com%2FShows%2FData-Exposed%3FWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EMicrosoft%20Docs%3C%2FA%3E%3CSPAN%3E%26nbsp%3Band%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fplaylist%3Flist%3DPLlrxD0HtieHieV7Jls72yFPSKyGqycbZR%26amp%3BWT.mc_id%3Ddataexposed-c9-niner%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EYouTube%3C%2FA%3E%3CSPAN%3E!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3457741%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22MSDataExposed.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F202729i490928FF0C962B7B%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSDataExposed.jpg%22%20alt%3D%22MSDataExposed.jpg%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ELearn%20how%20to%20export%20BACPAC%20files%20for%20Azure%20SQL%20database%20using%20Azure%20Automation.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3457741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Jun 01 2022 04:29 PM
Updated by: