This page lists all features supported for the Microsoft SQL Server database. HiDPi images on Mac Retina displays. Support for multiple SQL editors.

Can SQL Server engine express edition be installed on OS X? I use a MacBook at home and would like to use it as a testing/learning platform for SQL Server.

4 Answers

No, SQL Server will not run on macOS (it can run on Apple hardware, if you use Boot Camp and boot natively to Windows). Otherwise you will need to install virtualization software of some sort, where you install Windows in a VM, and install SQL Server there - I use Parallels Desktop, but there is also VMWare Fusion and Oracle VirtualBox.

_{(I haven't tested the latter recently, but last time I tried, it was a disaster - gets great reviews as a VM host on Windows, but not very stable on the Mac.)}

You can also, of course, RDP to other machines, use SSMS equivalent clients to connect to another SQL Server running on Windows elsewhere, or install a different platform on the Mac (such as PostgreSQL). There is also an IDE from JetBrains called DataGrip and I'm sure others I don't know about.

With SQL Server 2017, you can run SQL Server on Linux, and can even host your own docker container without using Windows at all (I am doing this on my Macs right now - and I wrote about it here).

VS Code, Visual Studio, and Operations Studio now run natively on the Mac, so that can work for you too in some scenarios. It all depends on whether you expect SQL Server to actually run on macOS, or if you just want to do most of your work there.

EDIT

Recently SQL Server was released for linux. This makes using Docker a viable solution to 'running sql server on mac'. You can find some details on how to do this here: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-docker.

Old answer

If you have a mac and do not want to run a virtual machine, there are a few options.

Free Photo Editor For Mac

1. You can grab a Azure trial and setup an SQL Server instance. Azure also provides a web based query interface.

2. You could also setup a Amazon RDS free account and create an SQL Server instance.

If you need an MSSQL database client which runs on OS X (similar to SSMS) there are a few available.

• SQLPro for MSSQL (also available on the mac app store) [Note: I am the developer of this app].

You can find a review of multiple clients here.

The command line tools are also available for Mac. (In case if it helps)https://blogs.technet.microsoft.com/dataplatforminsider/2017/04/03/sql-server-command-line-tools-for-mac-preview-now-available/

To run SQL on mac, we can run this using docker. Please follow the link below.

Unity is a powerful solution to create games for a multitude of platforms, from mobiles to consoles, desktop and web games. Since Unity 5.2, Visual Studio and the Visual Studio Tools for Unity have been the default experience on Windows.

When we released Visual Studio for Mac last year, Unity was among the first scenarios we supported out of the box. I’m happy to share that Unity will include Visual Studio for Mac as the default for macOS developers starting with version 2018.1.

This means that everyone will be able to utilize the benefits of the .NET 4.6 scripting runtime upgrade in Unity (currently an experimental feature) , including all the goodies of C# 6.0 and access to the Microsoft Azure SDK to add powerful cloud services to your games. This is all in addition to the existing one-click debugging, customized solution pad, IntelliSense autocompletion, and many more productivity features.

Check out my post “Unity game development with Visual Studio for Mac” for more information on all that Visual Studio for Mac has to offer for Unity developers, or watch the video below on how Visual Studio 2017 and Visual Studio for Mac boost your development productivity.

Video Editor For Mac

You can also read Unity’s announcement for more details.

Sql Server Editor For Mac

To get started today, download Visual Studio for Mac and set it as the default editor in Unity. Visual Studio Community for Mac is free to use for students, open-source and individual developers, as well as small teams. Check out the license terms for more information.

Mysql Editor For Mac

As always, let us know what you think in the comments below.