macOS SQL Tool?

[chameleon]

What do you folks use for an SQL Tool on the Mac?

I've tried a bunch since my "switch", and so far they all suck.

On Windows, there is Enterprise Manager, which is clunky, but it lets you do everything you need for SQL Server. Most importantly, you can just start typing to make changes to data in a table, add new rows, etc., and it's got a decent query builder

Thus far the best I've found on the Mac is RazorSQL, which makes me want to gouge my eyes out most of the time.

There must be something better.

Any advice?

 

[ScoobyMcDoo]

Have you tried any of the open source stuff like mysql or postgresql? I think they are available for OSX.

 

[ergdegdeg]

Yea, I use MySQL together with CocoaMySQL. Perfect Couple.

 

[jeremy.king]

DBVisualizer (Free Edition)

 

[ruckus]

for all of my personal work i have switched to mySql since the tools available are great, and platform independent.

 

[ChrisA]

What do you folks use for an SQL Tool on the Mac?

What is it that you need to do. Just enter SQL querries? Don't look for Mac specific tools. Anything that will run on UNIX-like systems wil run on the Mac. I'm using PosgreSQL here foe project and I find "psql" that ships with PostgreSQL to be good enough. It has comands for editing querries and examining the structure of tables. What else is needed?

 

[drivefast]

pgadmin here. for postgresql databases.

 

[AlmostThere]

AquaDataStudio (not free but well worth the asking price)

And if you are cross-platform (talking about the db here), Java will likely become a close friend.

 

[jeremy.king]

What else is needed?

Just like some people prefer Finder over Terminal, some people prefer SQL GUIs over command line...

 

[SC68Cal]

The Terminal to Finder allusion an insult to SQL GUI tools. Surely they're not as terrible as that. I mean, switching from XFile or Terminal to Finder is like trading your hammer in for a playskool hammer.

 

[chameleon]

Sorry, but many of you are missing the point. Perhaps I wasn't clear enough.

The database is, and always will be, Microsoft SQL Server.

What I need is a Mac based client that will allow me to query and manage the database. Something like Enterprise Manager on Windows.

 

[lee1210]

This isn't exactly what you were asking for, but:
http://www.microsoft.com/mac/downloads.mspx?fid=1d56fcd1-6001-4ae9-b7b6-2c2c631a7245#viewer

The path of least resistance, in my opinion. If you like enterprise manager, use it.

-Lee

 

[ChrisA]

Sorry, but many of you are missing the point. Perhaps I wasn't clear enough.

The database is, and always will be, Microsoft SQL Server.

What I need is a Mac based client that will allow me to query and manage the database. Something like Enterprise Manager on Windows.

Then run a copy of Enterprise Manager either under VMware or by a remote access program like VNC.

 

[jeremy.king]

Sorry, but many of you are missing the point. Perhaps I wasn't clear enough.

Did you even try DbVisualizer? It's quite good for the price.

 

[SC68Cal]

CocoaMySQL is a decent tool as well. I don't know how well it will work with MSSQL though, if at all.

 

[Thom_Edwards]

I don't know of anything like EM for Mac, but surely you could use Remote Desktop Connection to connect to the machine and run EM like that. I'm assuming if you access to SQL Server that it would not be a problem to connect via RDC. This takes the Boot Camp/Parallels/VMWare virtualization stuff out of the picture, meaning no Microsoft tax!

 

[chameleon]

Thanks to everyone who has replied so far.

Yes, I could use BootCamp / VMWare / Parallels, etc. I would much rather have a Native / Cocoa app -- if such a thing exists.

So far I've either found half-hearted efforts, or bloated Java apps.

I will give DbVisualizer a look, however.

Any other ideas?