Run SQL Server with Full-Text Search, on macOS (Apple Silicon), with Docker

compose.yml

# 1. git clone https://gist.github.com/113bc19a7dafeb05e646db9856ff9891.git sqlserver
# 2. cd sqlserver
# 3. docker compose up -d

services:
  sql-server:
    container_name: sqlserver
    build:
      dockerfile: Dockerfile
    ports:
      - 1433:1433
    environment:
      - ACCEPT_EULA=Y
      - MSSQL_SA_PASSWORD=YsRTKGCA3Egkb7pc

Dockerfile

# Based on https://tedspence.com/a-sql-server-docker-container-with-full-text-search-a1b7c5fc308c

FROM mcr.microsoft.com/mssql/server:2022-latest
USER root
RUN apt-get update && \
    apt-get install -yq gnupg gnupg2 gnupg1 curl apt-transport-https && \
    curl https://packages.microsoft.com/keys/microsoft.asc -o /var/opt/mssql/ms-key.cer && \
    apt-key add /var/opt/mssql/ms-key.cer && \
    curl https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list -o /etc/apt/sources.list.d/mssql-server-2022.list && \
    apt-get update && \
    apt-get install -y mssql-server-fts && \
    apt-get clean && \
    rm -rf /var/lib/apt/lists

ENTRYPOINT [ "/opt/mssql/bin/sqlservr" ]