#Copy sqlpackage utility and other required file to root of container

RUN apt-get install -y mssql-tools unixodbc-dev # Switch to root user for access to apt-get install Set permissions for the SQL user to run the script.Create a mount point folder that will point to the Azure File Share.Copy stored procedures to restore the database.Copy and unzip the sqlpackage.exe tool.Install the SQL Server tools, which will be needed for sqlcmd.exe.Pull the latest SQL Server image from the Microsoft repo.The Dockerfile will perform the following steps: If running Windows, you’ll also need Windows Subsystem for Linux (WSL). You will want to have Docker Desktop installed if you are running Windows or Mac. The full code to build this solution is in the Using an Azure Container Instance to convert BAK to BACPAC for Import into Azure SQL Database repository. The Azure resources used for this solution are: The conversion of the file could be achieved by creating a SQL Server VM in Azure and running the processes, but the start-up time is longer and the maintenance is unwanted. This solution is based entirely on Azure PaaS services. bacpac, copy it to Azure Blob Storage, and then import it into an Azure SQL Database. bak file that is in an Azure File Share, attach that File Share to an Azure Container Instance running SQL Server, restore the. In this solution, you will see how to take a. In some cases, you may not have direct access to the database to create a BACPAC, but you have the database. You can only import a BACPAC file you can’t attach a database or restore a backup. Importing an existing SQL Server database into an Azure SQL Database is not a trivial task. Thanks Jes! What problem are we trying to solve This post has been originally written by Jes Schultz ( Microsoft Software Engineer, that created a very interesting solution to solve a very common challenge, and that we want to share with you all.

Import bak files in azure sql on mac