Run 🚀 MS SQL (Azure Edge) on 🍏 Mac M1 4K

How to use MS SQL on Mac with M1.
Unfortunately, it doesn’t have Windows Authentication but for some projects it’s a very helpful solution.

1. docker pull mcr.microsoft.com/azure-sql-edge

2. sudo docker run –cap-add SYS_PTRACE -e ‘ACCEPT_EULA=1’ -e ‘MSSQL_SA_PASSWORD=your_password’ -p 1433:1433 –name sqtest -d mcr.microsoft.com/azure-sql-edge

3. sudo docker exec -it sqltest mkdir /var/opt/mssql/backup

4. sudo docker cp ./Downloads/AdventureWorks2019.bak sqltest:/var/opt/mssql/backup

Demo database (AdventureWorks):
https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms

Azure Data Studio:
https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver16

0:00 Introduction.
0:17 Run Docker Container.
0.47 Download .bak file and copy to container.
1:07 Restore database.

#sql #sqlserver #mssql #database #macOS #m1 #apple #db