Installing SQL-Server from Mac OS X with Docker
Microsoft SQL-Server runs full in Windows OS, but Microsoft has begun encouraging it on Linux. In Mac OS, to put in SQL-server, there’s a fantastic way to do it with docker, which employs the Linux edition of SQL-server. There’s an additional method by installing Windows OS from VM or utilizing Bootcamp. This manual indicates a step-by-step procedure of installing SQL-server from Mac OS X utilizing docker.
Proceed here https://docs.docker.com/v17.12/docker-for-mac/install/ and put in the stable model of docker. Install the docker (Docker.dmg) utilizing instructions from the aforementioned mentioned site. Open the downloaded Docker.dmg file.
After installed docker menu will appear in the primary name window.
Once started, it is possible to register in (or subscribe to docker hub if you don’t own an account) to find access to docker crystal pictures. (Not compulsory for installing SQL-server).
Then head to https://hub.docker.com/_/microsoft-mssql-server along with then copy-paste beneath control to pull docker picture of SQL-server.
docker pull mcr.microsoft.com/mssql/server
When the command mentioned above has been completed, you’ll get output something similar to in the below picture.
Then run the following command at the terminal to automatically conduct SQL-server docker picture by altering #### using a password of your selection (which afterward is utilized to link with SQL-server).
docker run -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD=####’ -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-CU8-ubuntu
Then check if your SQL-server is operating or not utilizing the below command.
After downloading the host, we’ll require client applications, which will let us compose SQL queries. I’m utilizing Azure Data Studio inside this manual (You can rather use DataGrip).
Download and set up Azure Data Studio for Mac OS utilizing the below link: https://docs.microsoft.com/en-us/sql/azure-data-studio/download?view=sql-server-ver15
You can replicate the information studio program to the Programs folder so which it is possible to get it on your Mac OS launchpad.
Click the localhost link after launching Info Studio. (as shown in the picture )
Type in the password that you used at a terminal while conducting SQL-server.
When the link is busy (symbolized with a green colored dot), you can begin writing SQL queries.