In this article, we will show how to run a database server in Docker. A running database is necessary for any ORIGAM development.
In case you don’t have Docker installed on your computer yet, please do it now. Here are general instructions.
If you are completely new to Docker, you may find useful this and also this video.
Image download
First, you need to download an image from which you can run your container.
In your command line (CMD or PowerShell in MS Windows or Terminal on MacOS), run the Docker pull command to download the image with the database server. You can use your own image or the following one:
docker pull mcr.microsoft.com/mssql/server:2022-latest
Container creation
Once the image is downloaded on your machine, you can create the container. Use your command line again, and this time run the following command. But before you do so, please replace the string yourStrong(!)Password with any password of your choice.
docker run -d -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=yourStrong(!)Password" --name mssql2022 -p 1433:1433 mcr.microsoft.com/mssql/server:2022-latest
Now there is a Docker container with the MS SQL database server running in your local Docker.
If you plan to use this database server not just for training purposes but in production, consider disabling the SA account as best security practice as described here.
In case you are having any trouble, you can check full instructions from Microsoft.