Category : sqlcmd

I am trying to setup a Microsoft SQL Server from a Docker image and load a script file that creates a database and adds a couple of file groups to that database. The dockerfile looks like this: # Get MSSQL image FROM mcr.microsoft.com/mssql/server:2017-CU24-ubuntu-16.04 # Set arguments (must be after FROM) ARG SA_PASSWORD=SecretComplexPassword1234! # Set environment ..

Read more

I create my MSSQL database docker container with only docker-compose.yml file and setup.sql file. My .yml file looks like that: 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" volumes: – ./data/mssql:/scripts/ command: – /bin/bash – -c – | # Launch MSSQL and send to background /opt/mssql/bin/sqlservr & ..

Read more

I’m new to SQL databases and to Docker containers. I’m trying to follow up a simple tutorial and I have started by downloading Docker and the MSSQL database (and its command tools). After it, I have tried to run the command sqlcmd to check if everything was fine until now and this error appears in ..

Read more

i am facing some weird error when trying to run SQLCMD from docker. below is the command i run docker run –volume /home/centos:/data –volume /var/run/docker.sock:/var/run/docker.sock -e TZ=Asia/Singapore -e TESTCONTAINERS_RYUK_ENABLED=false –workdir /data –rm -it mcr.microsoft.com/mssql-tools after i am in the docker’s bash, i run the command to restore the DB sqlcmd -S myIpAddress -U myUserid -P ..

Read more