Hello everyone, welcome back to Learn Tech Tips Blogspot. I am Zidane (大家好， 我是雞蛋🥚🥚)
Nice to meet you back. Today I will show you how to create Microsoft SQL Database Docker Compose file for you can easy deploy MSSQL on MACOS / LINUX OS, even on the WINDOW environement if you don’t wanna setup MSSQL in your PC, laptop
As you know when you working with Docker, you should know what is Docker?
If you are new in docker you can check below information.
👇
“Docker is a set of platform as a service products that use OS-level virtualization to deliver software in packages called containers. The service has both free and premium tiers. The software that hosts the containers is called Docker Engine. It was first started in 2013 and is developed by Docker, Inc”
If you already know docker, you can go through this topic right now.
👉 Tiktok
👉 Facebook:
Ok. Let’s back to topic
How to create a Docker Compose file for MSSQL Database Service
Docker container is a unit of software that packages up code and all its dependencies to allow the application to tun quickly and reliably from one computing environment to another. For laynching multiple docker containers, a YAML file is used by compose to initialize services for the app. Creating and lauching all of the functions is as simple as issuing a single command when configutation is complete
Ok. Let’s create a Docker compose file or Redis service. Just below some row you will get a redis service easily.
services:
mssqldb:
image: “mcr.microsoft.com/mssql/server:2017-latest”
container_name: mssqlserver
restart: always
hostname: mssqldb
environment:
SA_PASSWORD: Password123 #password /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P ‘Password123’
ACCEPT_EULA: Y
ports:
– “1433:1433” # port
volumes:
– “./rdmbs/mssql/data:/var/opt/mssql/data” # db
– “./rdmbs/mssql/backup:/var/opt/mssql/backup” # backup
