Steps to deploy microsoft sql server in docker container with docker-compose (Ubuntu) Change the image for other linux distributions for non Ubuntu
- $mkdir for the volume in docker-compose file
- $chown 1001 directory of the volume
- run the docker-compose file with $docker-compose up
- $docker exec -it "bash"
- add sqlcmd to path by $export PATH=$PATH:/opt/mssql/bin:/opt/mssql-tools/bin
- connect to sql server with $sqlcmd localhost -U sa -P