If not, right click on Databases and click “Refresh”. You now should be able to see your AdventureWorks db under Databases. You should be able to see AdventureWorks under data In this case, my file saved in my ~/Downloads directoryĭocker cp ~/Downloads/AdventureWorks2017.bak :/var/opt/mssql/data/īack to Azure Data Studios, click on your localhost connection, and click Restore in the Dashboard Check your container ID and copy over your file into the mssql directory in the container. ![]() Download AdventureWorks2017.bak (or whatever year) from.Password: (what you put in ) above when you ran the docker container.Or if you’ve used it before, under Connections, next to SERVERS, click the New Connection Icon You now have a SQL Server running locally Connect to your SQL Server using Azure Data Studio docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=" -p 1433:1433 -name sql1 -d /mssql/server:2017-latest ![]() ![]() ![]() Pull SQL Server sudo docker pull /mssql/server:2017-latest
0 Comments
Leave a Reply. |