3

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]?

4
  • Are you saying Microsoft sql server instance?
    – Saifur
    Feb 5, 2015 at 21:12
  • @Saifur pretty much, yeah.
    – RǢF
    Feb 5, 2015 at 21:19
  • You can run SQL for Linux on OS X via Docker. Instructions on this blog post : medium.com/@reverentgeek/… May 17, 2017 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, 2017 at 7:16

2 Answers 2

3

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

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

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 and acknowledge you have read our privacy policy.

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