Skip to content

mssql docker

Oleh Shklyar edited this page Dec 15, 2020 · 6 revisions

https://docs.microsoft.com/ru-ru/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash

sudo docker pull mcr.microsoft.com/mssql/server:2019-latest
sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Qwertyu8" \
   -p 1433:1433 --name mssql1 -h mssql1 \
   -d mcr.microsoft.com/mssql/server:2019-latest
sudo docker ps -a
sudo docker exec -it mssql1 "bash"
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "Qwertyu8"
CREATE DATABASE Vote
SELECT Name from sys.Databases
GO
USE Vote
CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT)
INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);
GO
SELECT * FROM Inventory WHERE quantity > 152;
GO
QUIT
sudo docker stop mssql1
sudo docker start mssql1
sudo docker exec -it mssql1 bash

Clone this wiki locally