I am using this script to setup a docker container running a sql server
FROM mcr.microsoft.com/mssql/server:2022-latest AS build
ENV ACCEPT_EULA=Y
ENV SA_PASSWORD="myPw12345!"
WORKDIR /tmp
COPY ./Docker .
RUN ( /opt/mssql/bin/sqlservr & ) | grep -q "Service Broker manager has started"
&& sleep 5
&& /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/create-cash-box-db.sql
&& /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/add-transaction-store.sql
&& /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/backup-cash-box-db.sql
&& /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/restore-basedata-backup.sql
&& /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/restore-transaction-offline-backup.sql
&& pkill sqlservr
&& sleep 1
but the output when i docker compose is:
ERROR: process "/bin/sh -c ( /opt/mssql/bin/sqlservr & ) | grep -q "Service Broker manager has started" && sleep 5 && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/create-cash-box-db.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/add-transaction-store.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/backup-cash-box-db.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/restore-basedata-backup.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/restore-transaction-offline-backup.sql && pkill sqlservr && sleep 1" did not complete successfully: exit code: 1
------
failed to solve: process "/bin/sh -c ( /opt/mssql/bin/sqlservr & ) | grep -q "Service Broker manager has started" && sleep 5 && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/create-cash-box-db.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/add-transaction-store.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/backup-cash-box-db.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/restore-basedata-backup.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/restore-transaction-offline-backup.sql && pkill sqlservr && sleep 1" did not complete successfully: exit code: 1
> [database 4/4] RUN ( /opt/mssql/bin/sqlservr & ) | grep -q "Service Broker manager has started" && sleep 5 && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/create-cash-box-db.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/add-transaction-store.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/backup-cash-box-db.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/restore-basedata-backup.sql && /opt/mssql-tools18/bin/sqlcmd -s localhost -U sa -P $sa_password -i /tmp/restore-transaction-offline-backup.sql && pkill sqlservr && sleep 1:
18.00 Sqlcmd: '/tmp/create-cash-box-db.sql': Unknown Option. Enter '-?' for help.
but as far as i can tell i used the command the right way according to the documentation:
https://learn.microsoft.com/en-us/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16&tabs=go%2Cwindows&pivots=cs1-bash#-i-input_fileinput_file2
i already checked if the path to the file is correct