I need to do some tests on a MS SQL (not MySQL) database. But without the burden of having to open a hosting account, create a remote database, connect to it, and remotely insert a million records.

I need to create a MS SQL Database locally on my computer only to be used on my computer - and I need to be able to import it using Navicat software.

How can we create a local MS SQL database on OS X [Yosemite]?

  • Are you saying Microsoft sql server instance? – Saifur Feb 5 '15 at 21:12
  • @Saifur pretty much, yeah. – RǢF Feb 5 '15 at 21:19
  • You can run SQL for Linux on OS X via Docker. Instructions on this blog post : medium.com/@reverentgeek/… – Bart Calixto May 17 '17 at 20:27
  • @BartCalixto Welcome to Software Recommendations! Thanks for this excellent element of answer. This site has a very strict rule: all answers must satisfy the answer guidelines. Your answer above did not comply with these guidelines, so I had to remove it. Please don't give up, read the guidelines and post again. It should give the main steps of the procedure, price/license information, and limitations if any. Thanks! – Nicolas Raoul May 23 '17 at 7:16

Unfortunately, you cannot install MS SQL server directly on OS X operating system. Only option is Windows servers/OS. See this

Then do you have any option? Yes. VMs

  1. Parallels: Virtualize the window OS and install that in there.
  2. Vmware Fusion: Virtualizing the OS

My personal preference is VMware Fusion. I used it and pretty simple and better than Parallels, at least for me.

And, unfortunately they are not free

  • VirtualBox is both Free and free and runs great on Mac. And Linux. And Windows. – ivanivan May 17 '17 at 22:28

A free (as a beer) setup could be like this:

This is a bit involved due to all downloads/installations and (unless you already have Windows) will only run for 90 days. Another option is to get an Amazon Instance with everything already installed, connect per RDP (CoRD is nice) and do your tests remotely.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.