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
add comment

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
add comment

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
add comment

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
add comment

You may like SQL Client.

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
add comment

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.