Using SQL Server in Docker

mssql-in-docker.md

Pull SQL Server image from docker hub.

docker pull mcr.microsoft.com/mssql/server

Start a mssql-server instance

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<your_password>" -p 1433:1433 -v sqlvolume:/var/opt/mssql --name mssql19 --hostname mssql19 -d mcr.microsoft.com/mssql/server:2019-latest

Connect to SQL Server using the sqlcmd tool inside the docker container.

docker exec -it mssql19 /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P <your_password>

Create a directory inside a docker container

docker exec -it mssql19 bash

mkdir tmp/files

exit

Copy files from host to docker container

docker cp <host-path-to-file-located-directory>/. mssql19:/tmp/files

Note: Need to copy files in docker container only for the SQL Server bulk import operations.