[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