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 SQLPro for MSSQL. (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
    
@Zanox Hi, does your app allow us to create a local MS SQL database on our mac OS X? Or do you know of any software or ways to create a MS SQL database on a mac to be used locally only? –  RǢF Feb 5 at 20:39
    
@RǢF, the app allows you to connect to a MSSQL server. It sounds like your looking to HOST a MSSQL server on OS X which I do not know of a way to do so. –  Kyle Feb 6 at 15:07

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 '14 at 19:01
    
@Priyeshj Yes I have heard now its working good –  Durai Amuthan.H Sep 13 '14 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 '14 at 18:45
2  
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 '14 at 18:06
1  
@Priyeshj Thanks for pointing out SQL Client I'll try –  Durai Amuthan.H Sep 17 '14 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.