Azure SQL Database

Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

Using an Azure Container Instance to convert a BAK to BACPAC for Import into Azure SQL Database

December 9, 2020 Dec 9, 2020 12/9/20

Davide Mauri

Importing a SQL Server backup into an Azure SQL Database is not a trivial task. Here's how to automate the process of converting a .bak to .bacpac file using Docker Containers, Powershell and some automation.

Azure SQL & .bacpac the easy way

August 31, 2020 Aug 31, 2020 08/31/20

Davide Mauri

Restoring an Azure SQL database in one - well three - simple scripts: one with Powershell, one with AZ CLI + Bash and one using the ubiquitous SqlPackage