Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I'm looking for a Mac app that has capabilities similar to Microsoft SQL Server Enterprise Manager.

The app should be capable of the following:

  • Create and administer SQL Server databases, objects, logins, users, and permissions
  • Define and execute SQL Server administrative tasks
  • Design and test SQL statements, batches, and scripts

Is an app like that available today?

share|improve this question

4 Answers 4

up vote 5 down vote accepted

Navicat offers a few products that can connect and manager a MSSQL Server. Their apps are available on the Mac App Store as well.

I have used their MySQL edition, as well as their lowest-cost option, Essentials (I think they used to have a free version).

While I haven't used it for all of the items you have below, it was great for some simple table management tasks.

share|improve this answer
    
Navicat looks promising. Thanks. –  tlatkovich Mar 9 '12 at 20:47

You may like SQL Client. (You can also get a trial at our website)

The app has a few neat features such as:

  • Syntax highlighting.
  • Intellisense.
  • Tabbed based interface.
  • Support for executing multiple queries at once.
  • Quick access to tables, columns and more.
  • Stored procedure execution.

Disclaimer: I'm the developer.

share|improve this answer

Froq supports multiple databases including SQL Server. I have used this app for Oracle and really like it. Can't speak to specifics of SQL Server support.

The author is also very responsive.

share|improve this answer

There is SQuirreL SQL which is cross-platform. It works great and supports so many data bases including SQL Server.

It's Open source and free.

share|improve this answer
1  
Last I checked, Squirrel's supporting plugin for MSSQL did not work at all. Did they fix it? –  Priyeshj Sep 12 at 19:01
    
@Priyeshj Yes I have heard now its working good –  Duraiamuthan.H Sep 13 at 6:26
1  
I tried just now, and the Microsoft MSSQL Server Driver doesn't seem to work for me out of the box (with the plugin installed). Moreover, it doesn't use the KeyChain on MAC and stores passwords as plain text. So it has been a turn off for me. Switched over to SQL Client, and it works like a charm. –  Priyeshj Sep 15 at 18:45
1  
SQL Client costs $20 after trial ends. It is worth it when cutting the time I used to try all the other free options out. –  Priyeshj Sep 16 at 18:06
1  
@Priyeshj Thanks for pointing out SQL Client I'll try –  Duraiamuthan.H Sep 17 at 6:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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