docker-compose-mssql.yml

services:
  waltz-mssql:
    image: ghcr.io/finos/waltz:mssql-alt
#    build:
#      context: .
#      dockerfile: Dockerfile.mssql
    ports:
      - "8080:8080"
    depends_on:
      sqlserver:
        condition: service_healthy
    environment:
      DB_HOST: sqlserver
      DB_PORT: "1433"
      DB_NAME: waltz
      DB_USER: sa
      DB_PASSWORD: "Waltz#123"
      DB_SCHEME: dbo

  sqlserver:
    image: hmxlabs/mssql-fts:2022-latest
    # note - this above image is a repackage of mssql and full text search.
    # if desired it can be rebuilt locally, but it takes much longer (uncommment below)
    #    build:
    #      dockerfile: docker/Dockerfile_MSSQL

    ports:
      - "1433:1433"
    environment:
      SA_PASSWORD: "Waltz#123"
      ACCEPT_EULA: "Y"
      MSSQL_PID: "Express"
    volumes:
      - waltz_mssqldata:/var/opt/mssql
    healthcheck:
      test: /opt/mssql-tools18/bin/sqlcmd -C -S localhost -U sa -P "Waltz#123" -Q "SELECT 1" || exit 1
      interval: 10s
      timeout: 5s
      retries: 30
      start_period: 30s

volumes:
  waltz_mssqldata:

# example run commands
# docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Waltz#123" -e "MSSQL_PID=Express"  -p 1433:1433 -d --name=sql mcr.microsoft.com/mssql/server:latest
# docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Waltz#123" -e "MSSQL_PID=Express" -p 1433:1433 -d --name=mssql-waltz hmxlabs/mssql-fts:2022-latest