DeployMsSqlDockerLinux/Readme at master · C485/DeployMsSqlDockerLinux · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
Example of Docker Compose with MS SQL 2019 (will work with 2022 aka preview, to use preview, replace everywhere 2019 to review).
Example install FTS aka full text search
Tested on Debian.

Read https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-docker-container-configure?view=sql-server-ver16&pivots=cs1-bash#persist

Before starting please check in console:
docker run --rm alpine ping -c 3 google.com

it should show ping to google.com, if there is an error do this:

nano /etc/docker/daemon.json
paste json and save(you can use your favorite dns):

{
  "dns": ["8.8.8.8", "8.8.4.4"]
}

run:

systemctl restart docker

check again:
docker run --rm alpine ping -c 3 google.com


commands to deploy:
mkdir mssql-with-fts
cd mssql-with-fts
nano docker-compose.yml
//// paste content of docker-compose.yml to nano and save
nano Dockerfile
//// paste content of Dockerfile to nano and save
docker compose up
//// this will start container in context of your console, see if there is no errors, ctrl+c to exit, this will stop container
docker compose start


///// for clean reinstall use command
docker compose down --rmi all -v
///// this will remove everything that was created/downloaded