PDA

View Full Version : SQL Tool?




chameleon
Mar 25, 2008, 02:18 PM
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
Mar 25, 2008, 02:20 PM
Have you tried any of the open source stuff like mysql or postgresql? I think they are available for OSX.

ergdegdeg
Mar 25, 2008, 02:23 PM
Yea, I use MySQL together with CocoaMySQL. Perfect Couple.

jeremy.king
Mar 25, 2008, 02:47 PM
DBVisualizer (http://www.dbvis.com/products/dbvis/) (Free Edition)

ruckus
Mar 25, 2008, 03:11 PM
for all of my personal work i have switched to mySql since the tools available are great, and platform independent.

ChrisA
Mar 25, 2008, 03:16 PM
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
Mar 25, 2008, 03:29 PM
pgadmin here. for postgresql databases.

AlmostThere
Mar 25, 2008, 03:55 PM
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
Mar 25, 2008, 03:58 PM
What else is needed?

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

SC68Cal
Mar 25, 2008, 04:18 PM
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
Mar 25, 2008, 04:57 PM
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
Mar 25, 2008, 06:20 PM
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
Mar 25, 2008, 08:01 PM
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
Mar 25, 2008, 08:29 PM
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
Mar 25, 2008, 11:05 PM
CocoaMySQL is a decent tool as well. I don't know how well it will work with MSSQL though, if at all.

Thom_Edwards
Mar 26, 2008, 12:47 AM
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
Mar 27, 2008, 09:15 AM
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?