version: '3.8'

services:
  # SQL Server 2022 - Baseline (Production)
  sqlserver-baseline:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: drt-sqlserver-baseline
    environment:
      - ACCEPT_EULA=Y
      - SA_PASSWORD=${SA_PASSWORD:-YourStrong!Passw0rd}
      - MSSQL_PID=Developer
    ports:
      - "1433:1433"
    volumes:
      - ./test_data/init_baseline.sql:/docker-entrypoint-initdb.d/init.sql
      - sqlserver_baseline_data:/var/opt/mssql
    healthcheck:
      test: /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P ${SA_PASSWORD:-YourStrong!Passw0rd} -Q "SELECT 1"
      interval: 10s
      timeout: 5s
      retries: 5
    networks:
      - drt-network

  # SQL Server 2022 - Target (Test)
  sqlserver-target:
    image: mcr.microsoft.com/mssql/server:2022-latest
    container_name: drt-sqlserver-target
    environment:
      - ACCEPT_EULA=Y
      - SA_PASSWORD=${SA_PASSWORD:-YourStrong!Passw0rd}
      - MSSQL_PID=Developer
    ports:
      - "1434:1433"
    volumes:
      - ./test_data/init_target.sql:/docker-entrypoint-initdb.d/init.sql
      - sqlserver_target_data:/var/opt/mssql
    healthcheck:
      test: /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P ${SA_PASSWORD:-YourStrong!Passw0rd} -Q "SELECT 1"
      interval: 10s
      timeout: 5s
      retries: 5
    networks:
      - drt-network

volumes:
  sqlserver_baseline_data:
  sqlserver_target_data:

networks:
  drt-network:
    driver: bridge