Run a sample query: SELECT StockItemID, StockItemName FROM WHERE StockItemID>=1
Docker mssql mac change password install#
In my case, the install fails due to the package six being available on my system, so the workaround is: sudo pip install mssql-cli -ignore-installed sixĬonnect to your SQL Server instance directly: mssql-cli -U SA -P 'CockroachDB1!' -S localhost,1433 -d WideWorldImporters Install the mssql-cli tool on your host: sudo pip install mssql-cli It is also easier to install than sqlcmd on my Mac. In the typical new Microsoft fashion, the GitHub page for the project can be found here. It is currently under heavy development and offers a more pleasant experience over sqlcmd, in my opinion. Mssql-cli is a CLI utility used to connect to SQL Server. Verify the restored database: docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \Īccess the SQL Server Docker Container From Your Host Using mssql-cli Q 'RESTORE DATABASE WideWorldImporters FROM DISK = "/var/opt/mssql/backup/wwi.bak" WITH MOVE "WWI_Primary" TO "/var/opt/mssql/data/WideWorldImporters.mdf", MOVE "WWI_UserData" TO "/var/opt/mssql/data/WideWorldImporters_userdata.ndf", MOVE "WWI_Log" TO "/var/opt/mssql/data/WideWorldImporters.ldf", MOVE "WWI_InMemory_Data_1" TO "/var/opt/mssql/data/WideWorldImporters_InMemory_Data_1"'
Q 'RESTORE FILELISTONLY FROM DISK = "/var/opt/mssql/backup/wwi.bak"' \Įxecute the restore command: docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \ List the logical names and paths for the backup: docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd -S localhost \ Restore a Backup File of WideWorldImporters Database in the ContainerĬreate a backup directory: docker exec -it sql1 mkdir /var/opt/mssql/backupĭownload WideWorldImporters database: curl -L -o wwi.bak ''Ĭopy the backup file into the container: docker cp wwi.bak sql1:/var/opt/mssql/backup Q 'ALTER LOGIN SA WITH PASSWORD="CockroachDB1!"' d /mssql/server:2019-GA-ubuntu-16.04Ĭhange password: docker exec -it sql1 /opt/mssql-tools/bin/sqlcmd \ Run the container: docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Cockroach!1' \
0 kommentar(er)
