Dogs and cats living together, mass hysteria! [Update Oct 3, 2017] This article has been updated to reflect changes in the latest release of SQL Server for Linux.

Current version of mac os. The 2016 Microsoft Connect(); event included a lot of interesting announcements. The one that really got my attention was.

My first question, of course: Can I run this on my Mac? The answer (and an increasingly common answer, I might add) is. Here are the steps that worked for me. Install and configure Docker If you don't already have Docker installed, you'll need to. Next step, you'll need to increase Docker's available memory to 4GB or more. • Docker -> Preferences • Increase Memory to at least 4GB • Click Apply & Restart Get the Docker image Open a Terminal window, and download the latest SQL Server for Linux Docker image.

SQLAPI++ for Mac OS X v.3.8.2.0 SQLAPI++ is a library designed to enable you to access multiple SQL databases (Oracle, SQL Server, DB2, Sybase, InterBase, Informix, SQLBase, MySQL, PostgreSQL and ODBC, SQLite). It uses native APIs of target DBMS so applications developed with. Microsoft office for mac os x yosemite download. You should now have SQL Server running on your Mac, ready for action! First step is to use SQL Server Management Studio to generate scripts from an existing database.

Docker pull microsoft/mssql-server-linux:2017-latest Now, launch an instance of the Docker image. Docker run -d --name name_your_container -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=P@55w0rd' -e 'MSSQL_PID=Developer' -p 1433:1433 microsoft/mssql-server-linux:2017-latest You should now have SQL Server running on your Mac, ready for action! A few notes on Docker parameters • -d: this launches the container in daemon mode, so it runs in the background • --name name_your_container: give your Docker container a friendly name, which is useful for stopping and starting containers from the Terminal. • -e 'ACCEPT_EULA=Y: this sets an environment variable in the container named ACCEPT_EULA to the value Y. This is required to run SQL Server for Linux. • -e 'SA_PASSWORD=P@55w0rd': this sets an environment variable for the sa database password.

Set this to your own strong password. Also required. • -e 'MSSQL_PID=Developer': this sets an environment variable to instruct SQL Server to run as the Developer Edition. • -p 1433:1433: this maps the local port 1433 to the container's port 1433. SQL Server, by default, listens for connections on TCP port 1433. • microsoft/mssql-server-linux: this final parameter tells Docker which image to use Tip: Get Kitematic Kitematic is a nice desktop application for managing Docker containers.

The first time you click Open Kitematic, it will prompt you to download and install it. You can then use Kitematic to view the output of your containers, manage their settings, etc. It's running, now what?