init-db.sh

#!/usr/bin/env bash
set -uo pipefail

#do this in a loop because the timing for when the SQL instance is ready is indeterminate
for i in {1..60};
do
    /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "$MSSQL_SA_PASSWORD" 
    if [ $? -eq 0 ]
    then
        echo "SQL Server initialization completed"
        break
    else
        echo "SQL Server not ready yet..."
        sleep 1
    fi
done

/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "$MSSQL_SA_PASSWORD" -i instnwnd.sql