Connect to a Docker SQL Server from your preferred SQL tool SQL Operations StudioĪs I wrote before one of the main reasons of my excitement about this all was release of SQL Operations Studio for Mac OS which is a free SQL Server tool that runs on Mac OS. detach microsoft/mssql-server-linux:2017-latestģ. volume /Users/sarbis/Desktop/DockerShared:/HostShared \
In my case I realized that I need it for copying db backup file and later restoring a db from it. It's good to have shared folder mapped when you would like to transfer some files into docker container. container name, SQL password) and also added shared folder mapping option my from host OS. I did some parameter value adjustments in the docker run comand (e.g. Run container image on your Docker engine. sudo docker pull microsoft/mssql-server-linux:2017-latestītw, really sweet progress bar for Docker CLI. I was totally fine with the latest SQL version so I went with that. Pull the SQL Server image from Docker Hub. Pull & Run SQL Server Docker container imageĪgain, this is also very simple (even without any previous Docker knowledge) if you follow the MSDN post. You can verify that Docker CLI is also successfully installed by running docker version command.Ģ. When you have completed installation you must have Docker whale icon visible in Mac OS menu bar.
That's a rather straightforward installation process, just follow the installation instructions on Docker site.
#DOCKER MAC OS IMAGE INSTALL#
Install Docker engine (Docker for Mac in my case) run basic table queries, create new users, grant permissions etc.
#DOCKER MAC OS IMAGE SOFTWARE#
That means I have to start my Windows VM every time I need to access some local database which takes some time obviously as well as running software on VM is not as resource-efficient as running similar software on native OS.īesides that SQL Server Management Studio (which I used before to connect to my local SQL databases) alone is a rather heavy piece of software, which is often more than you need to do a basic tasks with SQL Server e.g. Turned out it was easy to set up everything -> it is easy to use -> it performs much faster than on Parallels VM -> I'm happy -> I want to tell about this to others! :) ProblemĪs I mentioned before I rely on Parallels Desktop VM to run SQL Server local instance. So these are basically the reasons why I felt it was right time for me to try all these pieces stiching together and to see if I could get more freedom of Windows & Parallels Desktop. Finally the last thing which nailed it all was a message from another workmate in Geta Valdis Iljuconoks about the new lightweight SQL tool by Microsoft which can be run on Mac OS. And then few weeks ago somewhere on the Internet :) I ran into this MSDN post about running SQL Server 2017 container with Docker which reminded me that would be nice to test these things. :) Why Docker?ĭocker / containers / microservices has been a buzz words to me (from sessions in conferences, different blog posts, buddy in the company who have had hands-on experience with Docker - Klavs Prieditis) for a several years, but I never managed to discover these things more. As I mentioned, I take it in favor of having some other benefits of working on Mac OS. And obviously there haven't been easy solutions to run SQL Server natively on Mac OS, which requires me to run it on Windows hosted on Parallels Desktop VM, which in turn makes me sacrifice some host OS resources. This means that pretty much every developer in our company has to run local SQL Server instance for local development purposes on their computers. NET platform and obviously SQL Server is most common database engine choice in this context because it fits well with. Our company's core business is to produce web applications & services built on.
Won't go in more details about it this time but that is why I'm writing about Docker in Mac OS. I have Mac OS as my host OS for many years now and I really enjoy the benefits what I get using devices in so called "Mac ecosystem". I'm a web developer & CI/CD process administrator in my everyday work in Geta.
0 kommentar(er)
