MSSQL Client for Mac

appleii.c

macrumors 6502
Original poster
Mar 18, 2013
491
8
Hello all, I've been asked to help out on a project that uses Microsoft SQL as the DB. Can someone recommend a good OSX client to connect to mssql? I will need to run basic queries, possibly create some Sprocs (which can be done in an editor), and have general access to the DB. I'm not a fan of Dual Booting, or Parallels simply to use Microsoft's SQL Manager. What have you guys used?
 

CptSky

macrumors regular
Feb 1, 2013
140
13
Navicat is offering products for most DB systems (including SQL Server).

Personally, I use Navicat Premium Essentials which includes support for MySQL, SQL Server, SQLite, PostgreSQL, Oracle. Although I tend to use phpMyAdmin to with MySQL....

Available on the AppStore.
 

appleii.c

macrumors 6502
Original poster
Mar 18, 2013
491
8
Navicat is offering products for most DB systems (including SQL Server).

Personally, I use Navicat Premium Essentials which includes support for MySQL, SQL Server, SQLite, PostgreSQL, Oracle. Although I tend to use phpMyAdmin to with MySQL....

Available on the AppStore.
Thanks for your reply. I'll take a look at Navicat more closely. It looks promising. I gave RazorSQL a try and it was pretty good, but the $99 price tag may be a bit steep if I can find an alternative.
 

antonis

macrumors 68020
Jun 10, 2011
2,085
1,008
There's also a free option. SqlDeveloper from oracle is free and can connect to mssql as well as other databases.
 

D.T.

macrumors G4
Sep 15, 2011
10,901
11,537
Vilano Beach, FL
I know its an old post, but I'm the developer of SQLPro for MSSQL and I believe it to be a decent Microsoft SQL client.
It's a very solid product!

I haven't purchased a license yet, but I may soon. Occasionally I'm in MacOS and it's so handy to have a native MS SQL client vs. firing up a VM, switching to W10 via BC (when I don't have convenient access to my Windows dev machine). It doesn't come up _that often_ (which is the only reason I've been hesitant to drop $79 on it), but when I does, I always find myself thinking, "I need to buy this" especially now it's in out-of-trial-mode with the delayed results :D

I also looked at a few other products, the Java based ones were a little clunky, had odd UI elements, there was one that was cheap and reasonably full featured (the name escapes me), but it had this weird service type design, and I wasn't happy storing server creds outside of my own client app.
 

zenox

macrumors newbie
May 31, 2012
9
2
Canada
It's a very solid product!
Awesome, glad you like it so far!

the Java based ones were a little clunky, had odd UI elements
Java based apps are exactly why I created this product :) I hate the non-native feel of them on macOS and found that the native offers were lacking everything I needed.

PS - I've also released an iOS version of SQLPro for MSSQL (available for both iPhone and iPad). Its completely free for a single database connection. If you want to give it a try, I would love any feedback: https://itunes.apple.com/us/app/sqlpro-for-mssql/id1176218536?mt=8.
 

D.T.

macrumors G4
Sep 15, 2011
10,901
11,537
Vilano Beach, FL
PS - I've also released an iOS version of SQLPro for MSSQL (available for both iPhone and iPad). Its completely free for a single database connection. If you want to give it a try, I would love any feedback: https://itunes.apple.com/us/app/sqlpro-for-mssql/id1176218536?mt=8.
Oh wow, yes! For that _one_ time, when I'm away and I need SQL access from my iPhone, I'll gladly take a look. In the past, I'd RD into a machine, use SSMS , but most of our services are now running in some kind of cloud deployment, so no "desktop" so to speak.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.