In this recipe, we are going to spin up a Docker instance of a SQL Server database. To get started, you must install Docker.
The next step is to build and run a SQL Server database using docker:
docker pull mcr.microsoft.com/mssql/server:2017-latest
Then, run the Docker container:
docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_AGENT_ENABLED=true' \
-e 'MSSQL_PID=Standard' -e 'SA_PASSWORD=Password!' \
-p 1433:1433 --name sqlserver_1 \
-d mcr.microsoft.com/mssql/server:2017-latest
Now that we have a working SQL Server database, we need to add a database and two tables for it. You can connect to the SQL database by installing the mssql plugin for VS Code and then connecting to the database with the username and password we had in the Docker file:
Once you've done this, click on the new SQL Server tool in the left panel. Then, click on the plus (+) button...