postgres_mssql_compose.yml

services:
  mssql:
    image: mcr.microsoft.com/mssql/server:2019-latest
    container_name: mssql
    environment:
      ACCEPT_EULA: Y
      MSSQL_SA_PASSWORD: Mssql_2019
    ports:
      - 1433:1433
    entrypoint:
      - /usr/config/entrypoint.sh
    volumes:
      - ./sql/mssql_setup.sql:/usr/config/setup.sql
      - ./scripts/mssql_configure_db.sh:/usr/config/configure-db.sh
      - ./scripts/mssql_entrypoint.sh:/usr/config/entrypoint.sh

  postgres:
    image: docker.io/chumaky/postgres_tds_fdw:latest
    container_name: postgres
    environment:
      POSTGRES_PASSWORD: postgres
    ports:
      - 5432:5432
    volumes:
      - "./sql/postgres_mssql_setup.sql:/docker-entrypoint-initdb.d/postgres_mssql_setup.sql:z"
    depends_on:
      - mssql