How to correctly implement .sql file in MS SQL docker-compose.yml file?

  database, docker, docker-compose, sql-server, volumes

I have a problem implementing docker-compose.yml file for MS SQL Database container in Docker.
I tried to set up "setup.sql" file within "volumes:" parameter but it did not worked out for me. Maybe wrong path? How to correctly set up empty database using ready .sql file stored on local host computer?

Here is the code without volumes parameter:

version: "3.7"
services:
  sql-server-db:
    container_name: sql-server-db
    image: mcr.microsoft.com/mssql/server:2019-latest
    ports:
      - "1433:1433"
    environment:
        SA_PASSWORD: "secret123new!"
        ACCEPT_EULA: "Y"

Source: Docker Questions

LEAVE A COMMENT