52 lines
1.4 KiB
YAML
Executable File
52 lines
1.4 KiB
YAML
Executable File
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 |