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