ariazarifian/sql repository overview

⁠Please follow the following steps

⁠Table of content

• 1. Why Docker
• 2. Our tags
• 3. Pull image
• 4. Run our sql image

⁠1. Why docker

We've been using docker all the time in the smartcity project.

Indeed, it is a very simple and complete solution to set up.

We can isolate each service we use on a machine, so developers can have a more suitable working environment.

Docker also makes it possible to reduce production costs by using very little processor capacity.

Docker is completely modular, which means that we can configure our own image or use an already configured on,

it is very practical when we want to take a capture of our current image to deposit it on the repository of docker in public as in private.

⁠2. Our tags

We have several tags that allow you to use different versions of a container image. So, you must use the latest tag to get the most recent version of an image,

or the name of the tag you decided to choose. If you want another image, with another tag, we invite you to use our other rests. You will find them using the command

docker search ariazarifian/$chosetherepos

⁠3. Pull image

First of all, you have to download the docker image by using the next command in your terminal :

docker pull ariazarifian/$repos:latest

⁠4. Run our sql image

Use the following command in your terminal to run your sql image, and adapt it to your needs.

docker run --name=sqldev1 -e ACCEPT_EULA=Y \

-e MSSQL_PID="Enterprise" -e MSSQL_SA_PASSWORD="" \

-e MSSQL_ENABLE_HADR="1" -e MSSQL_AGENT_ENABLED="true" -p 1433:1433 -d ariazarifian/sql:latest

Manipulate in your container with the following command :

sudo docker exec -it sqldev1 /opt/mssql-tools/bin/sqlcmd
-S localhost -U SA -P ''
-Q 'SELECT @@VERSION'

⁠5. Commit and save your image

docker commit yourimage yourIDdockerhub/yourimage:yourtag

docker push yourimage yourIDdockerhub/yourimage:yourtag

Remember that you must login on docker on your terminal

If you want to push the code, do not hesitate to contact me to get the token access.

Aria