Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

MSSQL Client for Mac

appleii.c

appleii.c

macrumors 6502a
Original poster
Mar 18, 2013
531
40
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?
 
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.
 
CptSky said:
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.
Click to expand...

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.
 
There's also a free option. SqlDeveloper from oracle is free and can connect to mssql as well as other databases.
 
zenox said:
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.
Click to expand...

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.
 
D.T. said:
It's a very solid product!
Click to expand...

Awesome, glad you like it so far!

D.T. said:
the Java based ones were a little clunky, had odd UI elements
Click to expand...

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.
 
zenox said:
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.
Click to expand...

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.
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back