Step by Step Guide Installing SQL Server on a Mac and Restoring AdventureWorksDW2019 Database

This is a step-by-step guide on 'Installing SQL Server on a Mac and Restoring AdventureWorksDW2019 Database'. This tutorial covers the installation of SQL Server on a Mac and the restoration of the AdventureWorksDW2019 Database, a widely-used database for SQL practice. Ideal for students, data analysts, or developers looking to set up and use SQL Server on their Mac.

PREREQUISITES:
1. macOS must be version 11 or newer.
2. At least 4 GB of RAM. The higher, the better

Link to Docker Website in Step 1:
https://www.docker.com/products/docker-desktop

Terminal commands in Step 2 - Install SQL Server in Docker (Replace ”Password123” with a strong password of your choice):
FOR INTEL CHIP
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Password123" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest

FOR APPLE CHIP
docker run -e "ACCEPT_EULA=1" -e "MSSQL_SA_PASSWORD=Password123" -e "MSSQL_PID=Developer" -p 1433:1433 -d --name=sql mcr.microsoft.com/azure-sql-edge

Link to Azure Website in Step 3:
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

Link to Microsoft (AdventureWorks) Website in Step 5:
https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure

Terminal command in Step 6 (Replace “ContainerID” with the actual container ID from the container in docker):
Docker cp ~/Downloads/AdventureWorksDW2019.bak containerID:/var/opt/mssql/data/