Create a copy of docs/.env.example as docs/.env and set SA_PASSWORD.
The stack uses SQL Server 2025 Developer pinned to mcr.microsoft.com/mssql/server:2025-CU8-ubuntu-24.04. Compose maps SA_PASSWORD to the container’s MSSQL_SA_PASSWORD variable and stores data in the new sql-server-2025-data volume.
The retired Azure SQL Edge volume is not reused. Local database state is disposable by default; see SQL Server development database before attempting to preserve old data or running on Apple Silicon.
From repo root:
docker compose --env-file docs/.env -f docker-compose.yml -f docker-compose.prod.yml up -d --build
Note: docker-compose.prod.yml disables auto-migrate. Run migrations manually if needed.
docker compose --env-file docs/.env -f docker-compose.yml -f docker-compose.override.yml up -d --build