SQL Server does not support ARM, so yes, Docker may be the way to do. I say "may", because I have no idea if it actually works.
Installing MSSQL on Surface Laptop 7 with Snapdragon
I know there's been questions in the past when the ARM based MacBooks launched but now that Microsoft is shipping more ARM devices with the new Surface Pro and Surface Laptop is there any updated way to install and run MSSQL? Is Docker still the best approach on ARM based devices?
In the SQL Server docs there's this https://learn.microsoft.com/en-us/sql/linux/tutorial-restore-backup-in-sql-server-container?view=sql-server-ver16&tabs=cli. But it would be nice if there was official 'Windows on ARM' documentation for getting setup. (If there is I haven't found it but would be grateful if someone shared that link)
2 additional answers
Sort by: Oldest
-
Bruce (SqlWork.com) 62,546 Reputation points
2024-07-03T16:21:15.11+00:00 there is no official SQLServer arm64 support.
Docker on Mac arm systems has setting:
[] Use Rosetta for x86_64/amd64 emulation on Apple Silicon to enable running x86
which allows running x86_64/amd64 containers. while originally experimental, it has been added to the base package. this feature has been widely used to run SQLServer docker containers on apple silicon.
note: I don't believe anyone has created this feature for windows arm. docker for windows arm is fairly new.
-
Erland Sommarskog 108.6K Reputation points MVP
2024-07-03T16:42:33.6333333+00:00 I got a tip from an MVP colleague that the Prism emulation layer is the way to to: https://learn.microsoft.com/en-us/windows/arm/apps-on-arm-x86-emulation.
He thinks that you need Windows 11 24H2 for this to work, but I guess the brand-new surface comes with this version.