MSSQL 2017 CTP2.1 available
scara opened this issue · 4 comments
Refs: https://blogs.technet.microsoft.com/dataplatforminsider/2017/05/17/sql-server-2017-ctp-2-1-now-available/
Just a minor cleanup in the context of using this image to develop in Moodle running on MSSQL:
FROM microsoft/mssql-server-linux:ctp2-1
HTH,
Matteo
Yeah, I was previously using that tag: 80c18ae
The reason I switched was because I was having some annoying problems with the build of that tag not including the mssql tools. microsoft/mssql-docker#82
But seems it was probably caching on my side of a bad tag
TNX for the very fast reply, appreciated! 👍
FYI, from CTP 2.0:
$ docker run --rm -it microsoft/mssql-server-linux:ctp2-0 ls -lh /opt/mssql/bin/
total 3.9M
-rwxrwxr-x. 1 root root 2.5K Apr 20 16:51 compress-dump.sh
-rwxrwxr-x. 1 root root 12K Apr 20 16:51 generate-core.sh
-rwxrwxr-x. 1 root root 983 Apr 20 16:50 mssql-conf
-rwxrwxr-x. 1 root root 2.2M Apr 20 16:51 paldumper
-rwxrwxr-x. 1 root root 851K Apr 20 16:51 sqlpackage
-rwxrwxr-x. 1 root root 855K Apr 20 16:51 sqlservr
-rwxrwxr-x. 1 root root 3.3K Apr 20 16:50 sqlservr.sh
$ docker run --rm -it microsoft/mssql-server-linux:ctp2-0 ls -lh /opt/mssql-tools/bin total 5.5M
-rwxrwxr-x. 1 root root 1.1M Mar 29 02:36 bcp
-rwxrwxr-x. 1 root root 4.4M Mar 29 02:37 sqlcmd
compared to CTP 2.1 (note the missing of sqlservr.sh):
$ docker run --rm -it microsoft/mssql-server-linux:ctp2-1 ls -lh /opt/mssql/bin/
total 23M
-rwxrwxr-x. 1 root root 409 May 15 20:25 compress-dump.sh
-rwxrwxr-x. 1 root root 13K May 15 20:25 crash-support-functions.sh
-rwxrwxr-x. 1 root root 1.7K May 15 20:25 handle-crash.sh
-rwxrwxr-x. 1 root root 983 May 15 20:25 mssql-conf
-rwxrwxr-x. 1 root root 21M May 15 20:25 paldumper
-rwxrwxr-x. 1 root root 853K May 15 20:25 sqlpackage
-rwxrwxr-x. 1 root root 857K May 15 20:25 sqlservr
$ docker run --rm -it -p 1433:1433 microsoft/mssql-server-linux:ctp2-1 ls -lh /opt/mssql-tools/bin
total 5.5M
-rwxrwxr-x. 1 root root 1.1M Mar 29 02:36 bcp
-rwxrwxr-x. 1 root root 4.4M Mar 29 02:37 sqlcmd
$ docker run --rm -it microsoft/mssql-server-linux:ctp2-1 find / -name 'sqlservr*'
/opt/mssql/bin/sqlservr
/opt/mssql/lib/sqlservr.sfp
/usr/share/man/man1/sqlservr.1
and the relevant changes in the history of the image:
$ docker history --no-trunc microsoft/mssql-server-linux:ctp2-0
IMAGE CREATED CREATED BY SIZE COMMENT
sha256:7b1c26822d97d1865d7ebd88de1ff06c9e5d15e055ba40b8b980a9e2df36382d 7 weeks ago /bin/sh -c #(nop) CMD ["/bin/sh" "-c" "/opt/mssql/bin/sqlservr.sh"] 0 B
<missing> 7 weeks ago /bin/sh -c /install.sh 208 MB
<missing> 7 weeks ago /bin/sh -c #(nop) COPY dir:9f50de825718c74258cd8eb8118b2f1c489eff4ebc39e285a7af805d71297f26 in / 859 MB
<missing> 7 weeks ago /bin/sh -c #(nop) EXPOSE 1433/tcp 0 B
...
IMAGE CREATED CREATED BY SIZE COMMENT
sha256:5985832855cf1233b22c268d5f69c55b83e89e01679ec0869d8664fd11e8aff4 4 weeks ago /bin/sh -c #(nop) CMD ["/bin/sh" "-c" "/opt/mssql/bin/sqlservr"] 0 B
<missing> 4 weeks ago /bin/sh -c /install.sh 219 MB
<missing> 4 weeks ago /bin/sh -c #(nop) COPY dir:807be65232ac4bdd40d9ad12408828b98f83a1c892f1aa66d371350481594b32 in / 880 MB
<missing> 4 weeks ago /bin/sh -c #(nop) EXPOSE 1433/tcp 0 B
...
HTH,
Matteo
Thanks Matteo - that was an extremely useful hint!