{"id":1671,"date":"2023-01-13T06:41:45","date_gmt":"2023-01-13T14:41:45","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=1671"},"modified":"2023-10-04T10:18:07","modified_gmt":"2023-10-04T17:18:07","slug":"development-with-sql-in-containers-on-macos","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/development-with-sql-in-containers-on-macos\/","title":{"rendered":"Development with SQL in containers on macOS"},"content":{"rendered":"

There are a bunch of tools available<\/a> for developing with SQL on macOS, including the mssql extension for VS Code and the standalone yet-comfortably-familiar Azure Data Studio. As a developer, you might have heard about the Azure SQL Database emulator<\/a> and you’ve most certainly heard about deploying SQL in containers<\/a>. Most recently, a new option for running SQL containers locally on your arm64 (M1\/M2) Mac became available and it makes running full SQL Server images easier than ever.<\/p>\n

<\/p>\n

In the v4.16 release of Docker Desktop, support for using Rosetta for emulation of x86\/amd64 images was introduced as a beta feature,<\/a> enabling improved performance and stability for running container images built for x86\/amd64 on macOS 13 (Ventura).<\/p>\n

Run SQL Server 2022 on macOS<\/h2>\n

Once you’ve enabled the new option under Settings in the “Features in development” pane, your will restart the local container runtime to apply the changes.<\/p>\n

 <\/p>\n

\"Docker<\/a><\/p>\n

From here on, we can follow the usual steps to pull a container image and run it:<\/p>\n

docker pull mcr.microsoft.com\/mssql\/server:2022-latest\r\ndocker run -e \"ACCEPT_EULA=Y\" -e \"MSSQL_SA_PASSWORD=<YourStrong@Passw0rd>\" \\\r\n   -p 1433:1433 --name sql2022 --hostname sql2022 \\\r\n   -d \\\r\n   mcr.microsoft.com\/mssql\/server:2022-latest<\/code><\/pre>\n
When you run the\u00a0docker run<\/em> command for an amd64 image on a workstation with arm64, you will see a brief warning about the image architecture and the container id on the following line.<\/p>\n
WARNING: The requested image's platform (linux\/amd64) does not match the detected host platform (linux\/arm64\/v8) and no specific platform was requested<\/pre>\n
If you’d prefer not to receive the warning message, you can include\u00a0–platform linux\/amd64<\/em> in the\u00a0docker run<\/em> command.\u00a0 The informational warning alerts you to the emulation that will occur to run the image in that environment.<\/p>\n
With Rosetta emulation for amd64 enabled, the SQL Server container will generally run with an indiscernible performance impact due to the emulation of amd64 binaries for arm64 and is suitable for development purposes.\u00a0 The SQL instance is now available to connect locally, whether from a tool such as Azure Data Studio or from an application being developed and run locally.<\/p>\n
\"Docker<\/a><\/p>\n
Note:\u00a0<\/strong>If you have not installed Rosetta 2 on your machine, you may need to run this command:<\/p>\n
softwareupdate --install-rosetta<\/code><\/pre>\n
SQL container customization<\/h3>\n
We saw above an example command to pull the free Developer edition of SQL Server in a container and run it locally on port 1433.\u00a0 SQL containers can be customized with changes to the docker run<\/em> command or with a Dockerfile for further configuration. Some popular options are:<\/p>\n