Try Microsoft SQL Server Developer with Docker.
docker pull microsoft/mssql-server-windows-developer
|
| Pull Microsoft SQL Server Developer image |
Docker on Windows stores temporary files in
%systemdrive%\ProgramData\Docker\tmp folder
|
| Docker temporary folder on Windows |
|
| Docker windowsfilter (Storage Driver) folder |
Quit Docker, edit C:\ProgramData\Docker\config\daemon.json to move \ProgramData\Docker to another drive
|
| Edit daemon.json file to change location of \ProgramData\Docker folder |
Start docker and run docker info to check
 |
| Run docker info to check Docker Root Dir location |
Run
docker pull microsoft/mssql-server-windows-developer
 |
| Pull microsoft/mssql-server-windows-developer successfully |
Check windowsfilter folder's size
 |
| \ProgramData\Docker\windowsfilter folder's size |
Run and check
 |
| Run and check mssql-server-windows-developer |
 |
| Try connecting and then run sqlcmd to check version and list databases |
Microsoft SQL Server 2017 On Fedora Workstation 31
[tuyen@g73jh ~]$ docker pull microsoft/mssql-server-linux
Using default tag: latest
Trying to pull repository docker.io/microsoft/mssql-server-linux ...
sha256:9b700672670bb3db4b212e8aef841ca79eb2fce7d5975a5ce35b7129a9b90ec0: Pulling from docker.io/microsoft/mssql-server-linux
59ab41dd721a: Pull complete
57da90bec92c: Pull complete
06fe57530625: Pull complete
5a6315cba1ff: Pull complete
739f58768b3f: Pull complete
0b751601bca3: Pull complete
bcf04a22644a: Pull complete
6b5009e4f470: Pull complete
a9dca2f6722a: Pull complete
Digest: sha256:9b700672670bb3db4b212e8aef841ca79eb2fce7d5975a5ce35b7129a9b90ec0
Status: Downloaded newer image for docker.io/microsoft/mssql-server-linux:latest
[tuyen@g73jh ~]$
[tuyen@g73jh ~]$ docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
docker.io/microsoft/mssql-server-linux latest 314918ddaedf 15 months ago 1.35 GB
[tuyen@g73jh ~]$
[tuyen@g73jh ~]$ docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Weak@Passw0rd" \
> -p 1433:1433 --name mssql1 \
> -d docker.io/microsoft/mssql-server-linux
1a1e5311c9b6e5061ade3107d4641f7286810672eb9c6b6a80f55df2a83df661
[tuyen@g73jh ~]$
[tuyen@g73jh ~]$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
1a1e5311c9b6 docker.io/microsoft/mssql-server-linux "/opt/mssql/bin/sq..." 2 minutes ago Up 2 minutes 0.0.0.0:1433->1433/tcp mssql1
[tuyen@g73jh ~]$
[tuyen@g73jh ~]$ docker exec -it mssql1 bash
root@1a1e5311c9b6:/# /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P Weak@Passw0rd
1> PRINT @@VERSION
2> GO
Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64)
Nov 30 2018 12:57:58
Copyright (C) 2017 Microsoft Corporation
Developer Edition (64-bit) on Linux (Ubuntu 16.04.5 LTS)
1> quit
root@1a1e5311c9b6:/# exit
exit
[tuyen@g73jh ~]$
Microsoft SQL Server 2019 on Fedora Workstation 31
[tuyen@g73jh ~]$ docker pull mcr.microsoft.com/mssql/server:2019-latest
Trying to pull repository mcr.microsoft.com/mssql/server ...
sha256:360f6e6da94fa0c5ec9cbe6e391f411b8d6e26826fe57a39a70a2e9f745afd82: Pulling from mcr.microsoft.com/mssql/server
5b7339215d1d: Pull complete
14ca88e9f672: Pull complete
a31c3b1caad4: Pull complete
b054a26005b7: Pull complete
59f979819d9b: Pull complete
29eb18117119: Pull complete
9a00f22bcd90: Pull complete
1a5a58ce1097: Pull complete
Digest: sha256:360f6e6da94fa0c5ec9cbe6e391f411b8d6e26826fe57a39a70a2e9f745afd82
Status: Downloaded newer image for mcr.microsoft.com/mssql/server:2019-latest
[tuyen@g73jh ~]$ docker images
REPOSITORY TAG IMAGE ID CREATED SIZE
mcr.microsoft.com/mssql/server 2019-latest d60e9ac97708 6 weeks ago 1.5 GB
tuyendq/node-web-app latest 8df58ad6be14 5 months ago 151 MB
django_web latest d4b154d71ca3 6 months ago 975 MB
hanzi v1 0da9b154230f 6 months ago 21.5 MB
docker.io/node 10-slim 7a5e19754b85 6 months ago 148 MB
docker.io/nginx alpine b6753551581f 6 months ago 21.4 MB
docker.io/python 3 d6a7b0694364 6 months ago 932 MB
docker.io/mysql latest c8ee894bd2bd 6 months ago 456 MB
docker.io/postgres latest f88dfa384cc4 6 months ago 348 MB
alpine latest 961769676411 8 months ago 5.58 MB
docker.io/alpine latest 961769676411 8 months ago 5.58 MB
gns3/ipterm latest 39d9f0350e12 15 months ago 148 MB
docker.io/microsoft/mssql-server-linux latest 314918ddaedf 17 months ago 1.35 GB
[tuyen@g73jh ~]$ docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Weak@Passw0rd" \
> -p 1433:1433 --name mssql2019 \
> -d mcr.microsoft.com/mssql/server
Unable to find image 'mcr.microsoft.com/mssql/server:latest' locally
Trying to pull repository mcr.microsoft.com/mssql/server ...
sha256:360f6e6da94fa0c5ec9cbe6e391f411b8d6e26826fe57a39a70a2e9f745afd82: Pulling from mcr.microsoft.com/mssql/server
Digest: sha256:360f6e6da94fa0c5ec9cbe6e391f411b8d6e26826fe57a39a70a2e9f745afd82
Status: Image is up to date for mcr.microsoft.com/mssql/server:latest
2b31eec6e722ba765a8cc1e6a0ae74783cc835b7e7eb300c7e3f23de56536d13
[tuyen@g73jh ~]$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
2b31eec6e722 mcr.microsoft.com/mssql/server "/opt/mssql/bin/pe..." 32 seconds ago Up 31 seconds 0.0.0.0:1433->1433/tcp mssql2019
[tuyen@g73jh ~]$ docker exec -it mssql2019 bash
mssql@2b31eec6e722:/$ /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P Weak@Passw0rd
1> PRINT @@VERSION
2> GO
Microsoft SQL Server 2019 (RTM-CU4) (KB4548597) - 15.0.4033.1 (X64)
Mar 14 2020 16:10:35
Copyright (C) 2019 Microsoft Corporation
Developer Edition (64-bit) on Linux (Ubuntu 18.04.4 LTS)
1> quit
mssql@2b31eec6e722:/$
