SQL Tool?

Discussion in 'Mac Programming' started by chameleon, Mar 25, 2008.

  1. macrumors regular

    chameleon

    Joined:
    Mar 4, 2006
    Location:
    Albany, NY
    #1
    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?
     
  2. macrumors 65816

    Joined:
    Nov 26, 2007
    Location:
    Austin, TX
    #2
    Have you tried any of the open source stuff like mysql or postgresql? I think they are available for OSX.
     
  3. Moderator emeritus

    ergdegdeg

    Joined:
    Oct 13, 2007
    Location:
    Nebraska
    #3
    Yea, I use MySQL together with CocoaMySQL. Perfect Couple.
     
  4. macrumors 603

    jeremy.king

    Joined:
    Jul 23, 2002
    Location:
    Fuquay Varina, NC
    #4
  5. macrumors regular

    ruckus

    Joined:
    Oct 19, 2005
    #5
    for all of my personal work i have switched to mySql since the tools available are great, and platform independent.
     
  6. macrumors G4

    Joined:
    Jan 5, 2006
    Location:
    Redondo Beach, California
    #6
    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?
     
  7. macrumors regular

    Joined:
    Mar 13, 2008
    #7
    pgadmin here. for postgresql databases.
     
  8. macrumors 6502a

    #8
    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.
     
  9. macrumors 603

    jeremy.king

    Joined:
    Jul 23, 2002
    Location:
    Fuquay Varina, NC
    #9
    Just like some people prefer Finder over Terminal, some people prefer SQL GUIs over command line...
     
  10. macrumors 68000

    Joined:
    Feb 23, 2006
    #10
    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.
     
  11. thread starter macrumors regular

    chameleon

    Joined:
    Mar 4, 2006
    Location:
    Albany, NY
    #11
    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.
     
  12. macrumors 68040

    lee1210

    Joined:
    Jan 10, 2005
    Location:
    Dallas, TX
    #12
  13. macrumors G4

    Joined:
    Jan 5, 2006
    Location:
    Redondo Beach, California
    #13
    Then run a copy of Enterprise Manager either under VMware or by a remote access program like VNC.
     
  14. macrumors 603

    jeremy.king

    Joined:
    Jul 23, 2002
    Location:
    Fuquay Varina, NC
    #14
    Did you even try DbVisualizer? It's quite good for the price.
     
  15. macrumors 68000

    Joined:
    Feb 23, 2006
    #15
    CocoaMySQL is a decent tool as well. I don't know how well it will work with MSSQL though, if at all.
     
  16. macrumors regular

    Joined:
    Apr 11, 2003
    #16
    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!
     
  17. thread starter macrumors regular

    chameleon

    Joined:
    Mar 4, 2006
    Location:
    Albany, NY
    #17
    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?
     

Share This Page