This is made possible by running SQL Server from a Docker container. Therefore, there's no need to install a virtual machine with Windows (which was the only way to run SQL Server on a Mac prior to SQL Server 2017). Install and Configure Docker. This is a prerequisite for installing SQL Server on your Mac. Installing with SQL Server on a non-Microsoft platform was not possible prior to the recent release of SQL Server 2017. Many.NET developers who wanted to install & run SQL Server on mac were forced to use a remote server or use a virtualisation technology. Download and Install SQL Server 2017 Express edition on Mac and Windows Download and Install Azure Data Studio on Mac and Windows Download and Restore a sample database (AdventureWorks) to SQL Server on Mac and Windows $100,000. Another SQL Server GUI tool that you can use on your Mac (and Windows/Linux/Solaris) is DBeaver. DBeaver is a free, open source database management tool that can be used on most database management systems (such as MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, Microsoft Access, Teradata, Firebird, Derby, and more).

So you use a Mac, but you need to run Microsoft SQL Server. I never thought this would be so easy, but here's how I've been doing this for the past few years.

How can I connect to a remote SQL server using Mac OS X? I don't really need a GUI, but it would be nice to have for the color coding and resultset grid. I'd rather not have to use a VM. Is there a SQL client for Mac OS X that works with MS SQL Server?

Microsoft Sql Server Free Download

You need Docker

If you already have docker installed, great news for you, you can skip to the next step. If not, go and download docker for mac.

Once you have docker for Mac installed you should be able to run docker-compose -v from Terminal and it should output the version number.

Microsoft Sql Server 2016 Download

Create a docker-compose.yml file

Microsoft Sql Server Download

Docker Compose lets you define one or more servers (or docker containers) in a single YAML file. We will use docker-compose.yml to make it very easy to start or stop SQL Server on our Mac.

You don't have to use docker-compose but I find it makes the process easy, especially if you leave a project and come back to it 6 months later.

Here's a simple docker-compose.yml file for running SQL Server on a Mac.

A few key points here. The ports section is mapping SQL Server port 1433 to my local port 1401. The password for the SA account will be set to the value of my DB_PASS environment variable, you may want to change how that works to suit your needs.

Now I have a sub folder called db with a few other files. The folder structure looks like this:

Let's take a look at run.sh

Install Sql Server On Mac

Here is import.sh

If you are not working with a SQL Server backup and just have some SQL create statements, you can just put them in mods.sql and comment out the line of the script that imports the database from a backup.

Now Start SQL Server

Just run the following in terminal from the directory that has your docker-compose.yml file:

At this point it should boot up SQLServer. It will be listening on port 1401, you can connect to it using SA and the password you set (eg DB_PASS environment variable).

Note that we could have done everything from the docker-compose.yml file if we wanted to, but I decided to break it up into scripts. This makes it easier to maintain a list of DB modifications or additions in the mods.sql file for example.

That's all there is to it, you've now installed SQL Server on your Mac! If you knew the Microsoft of the 90's you probably never would have thought it would be so easy to install SQL Server on a Mac and especially on Linux as it is in 2020.