MSSQL Client for Mac

Discussion in 'Mac Basics and Help' started by appleii.c, Jan 22, 2014.

  1. appleii.c macrumors 6502

    appleii.c

    Joined:
    Mar 18, 2013
    #1
    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?
     
  2. CptSky macrumors regular

    Joined:
    Feb 1, 2013
    #2
    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.
     
  3. appleii.c thread starter macrumors 6502

    appleii.c

    Joined:
    Mar 18, 2013
    #3
    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.
     
  4. antonis macrumors 68020

    antonis

    Joined:
    Jun 10, 2011
    #4
    There's also a free option. SqlDeveloper from oracle is free and can connect to mssql as well as other databases.
     
  5. Roquefort macrumors member

    Joined:
    Apr 29, 2005
    Location:
    U.S. west coast
    #5
    For Microsoft SQL Server, I've had the best luck with Oracle SQL Developer, which is free.

    For MySQL, I've used Sequel Pro, which is donationware.
     
  6. zenox macrumors newbie

    zenox

    Joined:
    May 31, 2012
    Location:
    Canada
    #6
    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.
     
  7. superscape macrumors 6502a

    superscape

    Joined:
    Feb 12, 2008
    Location:
    East Riding of Yorkshire, UK
    #7
    Thanks for that.

    I've never found an MSSQL client for Mac that I've liked - I'll happily give yours a try!
     
  8. D.T. macrumors G3

    D.T.

    Joined:
    Sep 15, 2011
    Location:
    Vilano Beach, FL
    #8
    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.
     
  9. zenox macrumors newbie

    zenox

    Joined:
    May 31, 2012
    Location:
    Canada
    #9
    Awesome, glad you like it so far!

    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.
     
  10. D.T. macrumors G3

    D.T.

    Joined:
    Sep 15, 2011
    Location:
    Vilano Beach, FL
    #10
    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.
     

Share This Page