p HOST:CONTAINER allows you to map the ports between the container and the host. e “SA_PASSWORD=” sets the sys admin password for the instance e “ACCEPT_EULA=Y” accepts the user license agreement The command is simply the following:ĭocker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=YOURSTRONGPASSWORDHERE" -p 1401:1433 -name sqldocker1 -h sqldocker1 -d /mssql/server:2019-latestįor this command we are doing a few simple things to get the container up and running. First we want to pull the latest image of the version of SQL Server that we want for this tutorial I will be using SQL Server 2019 running on Ubuntu Linux. This is pretty easy, you can use the command prompt or powershell for this next step. So now we need to start getting our container images downloaded so we can use them. I’m on a Windows machine, so it wasn’t too difficult following the instructions on these two links:Īfter a successful installation your docker application should look something like mine (except with no Containers/Apps or Images available). It is intended to be for beginners and in no way is an article for best practices or production deployments.įirst step is to actually get docker installed and configured. In these series of posts, I’m going to document my process of creating a Mini Data Lab for SQL Server on my desktop using Docker. I decided to try to make this process easier instead of going the traditional route of creating a Virtual Machine and also to help me learn a new technology. I had a customer that requested some specific code to be tested, and I realized that I didn’t have my own local instance of SQL running (always good to have a local one). Recently, with the help of a colleague at work, I’ve started to dabble a little with containers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |