docker build mssql server
[root@nckmvdsla19211 ~]# service docker start
Redirecting to /bin/systemctl start docker.service
[root@nckmvdsla19211 ~]# sudo docker pull microsoft/mssql-server-linux:2017-latest
Trying to pull repository registry.access.redhat.com/microsoft/mssql-server-linux ...
Trying to pull repository docker.io/microsoft/mssql-server-linux ...
2017-latest: Pulling from docker.io/microsoft/mssql-server-linux
f6fa9a861b90: Pull complete
da7318603015: Pull complete
6a8bd10c9278: Pull complete
d5a40291440f: Pull complete
bbdd8a83c0f1: Pull complete
3a52205d40a6: Pull complete
6192691706e8: Pull complete
1a658a9035fb: Pull complete
103fa96eca85: Pull complete
4105e5c7e280: Pull complete
Digest: sha256:4ef33b1d0b2f264550c152e24a87322daae40b090d3ba32f1241cb0fd4510421
Status: Downloaded newer image for docker.io/microsoft/mssql-server-linux:2017-latest
[root@nckmvdsla19211 ~]# docker pull microsoft/mssql-server-linux:2017-latest
Trying to pull repository registry.access.redhat.com/microsoft/mssql-server-linux ...
Trying to pull repository docker.io/microsoft/mssql-server-linux ...
2017-latest: Pulling from docker.io/microsoft/mssql-server-linux
f6fa9a861b90: Already exists
da7318603015: Already exists
6a8bd10c9278: Already exists
d5a40291440f: Already exists
bbdd8a83c0f1: Already exists
3a52205d40a6: Already exists
6192691706e8: Already exists
1a658a9035fb: Already exists
103fa96eca85: Already exists
4105e5c7e280: Already exists
Digest: sha256:4ef33b1d0b2f264550c152e24a87322daae40b090d3ba32f1241cb0fd4510421
Status: Image is up to date for docker.io/microsoft/mssql-server-linux:2017-latest
[root@nckmvdsla19211 ~]# sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' \
> -p 1433:1433 --name sql1 \
> sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' -p 1433:1433 --name sql1 \^C
[root@nckmvdsla19211 ~]# sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' \
> -p 1433:1433 --name sql1 \
> -d microsoft/mssql-server-linux:2017-latest
00421c5d12ad4a6a6e004c29aa57ce38af6efdc68dc01a52ddce62f395363b23
[root@nckmvdsla19211 ~]# sudo docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
00421c5d12ad microsoft/mssql-server-linux:2017-latest "/opt/mssql/bin/sq..." 11 seconds ago Up 10 seconds 0.0.0.0:1433->1433/tcp sql1
1e0c1fb27fc4 mysql/mysql-cluster "/entrypoint.sh ndbd" 4 weeks ago Created ndb1
b9dd73dc9eb7 mysql/mysql-cluster "/entrypoint.sh nd..." 4 weeks ago Created management1
abfe2ce47b6d hello-world "/hello" 4 weeks ago Exited (0) 4 weeks ago friendly_gates
[root@nckmvdsla19211 ~]# sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
> -S localhost -U SA -P '<YourStrong!Passw0rd>' \
> -Q 'ALTER LOGIN SA WITH PASSWORD="<YourNewStrong!Passw0rd>"'
[root@nckmvdsla19211 ~]# sudo docker exec -it sql1 "bash"
root@00421c5d12ad:/# /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourNewStrong!Passw0rd>'
1> CREATE DATABASE TestDB
2> ;
3>
Sqlcmd: Warning: The last operation was terminated because the user pressed CTRL+C.
root@00421c5d12ad:/# sudo docker exec -it sql1 "bash"
bash: sudo: command not found
root@00421c5d12ad:/# CREATE DATABASE TestDB;
bash: CREATE: command not found
root@00421c5d12ad:/# ls
bin core etc install.sh lib64 mnt proc run srv tmp var
boot dev home lib media opt root sbin sys usr
root@00421c5d12ad:/# cd bin
root@00421c5d12ad:/bin# ls
bash gzexe sync
bunzip2 gzip systemctl
bzcat hostname systemd
bzcmp journalctl systemd-ask-password
bzdiff kill systemd-escape
bzegrep ln systemd-inhibit
bzexe login systemd-machine-id-setup
bzfgrep loginctl systemd-notify
bzgrep ls systemd-tmpfiles
bzip2 lsblk systemd-tty-ask-password-agent
bzip2recover mkdir tailf
bzless mknod tar
bzmore mktemp tempfile
cat more touch
chgrp mount true
chmod mountpoint umount
chown mv uname
cp networkctl uncompress
dash nisdomainname vdir
date pidof wdctl
dd ps which
df pwd ypdomainname
dir rbash zcat
dmesg readlink zcmp
dnsdomainname rm zdiff
domainname rmdir zegrep
echo run-parts zfgrep
egrep sed zforce
false sh zgrep
fgrep sh.distrib zless
findmnt sleep zmore
grep stty znew
gunzip su
root@00421c5d12ad:/bin# cd ..
root@00421c5d12ad:/# /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourNewStrong!Passw0rd>'
1> CREATE DATABASE TestDB
2> ;
3> sqlcmd
4> ;
5> exit
root@00421c5d12ad:/# sqlcmd
bash: sqlcmd: command not found
root@00421c5d12ad:/# /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourNewStrong!Passw0rd>'
1> SELECT Name from sys.Databases
2> SELECT Name from sys.Databases;
3> go
Name
--------------------------------------------------------------------------------------------------------------------------------
master
tempdb
model
msdb
(4 rows affected)
Name
--------------------------------------------------------------------------------------------------------------------------------
master
tempdb
model
msdb
(4 rows affected)
1> CREATE DATABASE TestDB
2> go
1> SELECT Name from sys.Databases
2> go
Name
--------------------------------------------------------------------------------------------------------------------------------
master
tempdb
model
msdb
TestDB
(5 rows affected)
1> USE TestDB
2> go
Changed database context to 'TestDB'.
1> CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT)
2> go
1> VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);
2> go
(1 rows affected)
(1 rows affected)
1> SELECT * FROM Inventory WHERE quantity > 152;
2> go
id name quantity
----------- -------------------------------------------------- -----------
2 orange 154
(1 rows affected)
1>
[root@nckmvdsla19211 ~]# sudo docker exec -it sql1 mkdir /var/opt/mssql/backup
You have new mail in /var/spool/mail/root
[root@nckmvdsla19211 ~]# cd ~
[root@nckmvdsla19211 ~]# curl -L -o wwi.bak 'https://github.com/Microsoft/sql-server-samples/releases/download/wide-world-importers-v1.0/WideWorldImporters-Full.bak'
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 617 0 617 0 0 755 0 --:--:-- --:--:-- --:--:-- 755
100 121M 100 121M 0 0 19.8M 0 0:00:06 0:00:06 --:--:-- 25.0M
[root@nckmvdsla19211 ~]# sudo docker cp wwi.bak sql1:/var/opt/mssql/backup
[root@nckmvdsla19211 ~]# sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd -S localhost \
> -U SA -P '<YourNewStrong!Passw0rd>' \
> -Q 'RESTORE FILELISTONLY FROM DISK = "/var/opt/mssql/backup/wwi.bak"' \
> | tr -s ' ' | cut -d ' ' -f 1-2
LogicalName PhysicalName
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WWI_Primary D:\Data\WideWorldImporters.mdf
WWI_UserData D:\Data\WideWorldImporters_UserData.ndf
WWI_Log E:\Log\WideWorldImporters.ldf
WWI_InMemory_Data_1 D:\Data\WideWorldImporters_InMemory_Data_1
(4 rows
[root@nckmvdsla19211 ~]# sudo docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \
> -S localhost -U SA -P '<YourNewStrong!Passw0rd>' \
> -Q 'SELECT Name FROM sys.Databases'
Name
--------------------------------------------------------------------------------------------------------------------------------
master
tempdb
model
msdb
TestDB
(5 rows affected)
Comments
Post a Comment