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.yml 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
