[Mac OS] Restore MSSQL Database from .bak file using Azure Data Studio

Prerequisite

• a bak file (if you don’t have one, you can download from https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=data-studio)

1. Download and install Azure Data Studio

• Download Azure Data Studio for macOS (download immediately or go to Microsoft page & download the MacOS version)
• To expand the contents of the .zip file, double-click it
• To make Azure Data Studio available in Launchpad, drag the Azure Data Studio.app file to the Applications folder.

2. Install Docker Desktop on Mac

• Download and install Docker at https://docs.docker.com/desktop/install/mac-install/
• Double-click Docker.dmg to open the installer, then drag the Docker icon to the Applications folder
• Double-click Docker.app in the Applications folder to start Docker.

3. Pull and run the SQL Server Linux container image

• Enter the command below in the Terminal to pull the SQL Server 2022 Linux container image:

docker pull…