services:
  mssql-server:
    image: mcr.microsoft.com/mssql/server:2019-latest
    container_name: mssql-server
    environment:
      ACCEPT_EULA: "Y"
      SA_PASSWORD: "StrongP@ssw0rd!"
      MSSQL_PID: "Express"
    ports:
      - "1433:1433"
    volumes:
      - mssql_data:/var/opt/mssql
    networks:
      - mssql-network
    restart: unless-stopped

  sqlcmd:
    image: mcr.microsoft.com/mssql-tools
    container_name: sqlcmd
    depends_on:
      - mssql-server
    networks:
      - mssql-network
    entrypoint: /opt/mssql-tools/bin/sqlcmd
    command: -S mssql-server -U sa -P 'StrongP@ssw0rd!' -Q 'SELECT @@VERSION'

volumes:
  mssql_data:

networks:
  mssql-network: