How to connect to a SQL Server?

Discussion in 'macOS' started by Koreos, Dec 8, 2009.

  1. Koreos macrumors member

    Joined:
    Mar 4, 2008
    #1
    Hello everyone,

    For my final project in my Java class, we have to code a program that will access a SQL database. That is fine with me, but I was wondering if there's any kind of SQL database browser client for the mac. With that, I mean something that will ask me the server's address, user and password and let me see the database's tables and structures.

    Thank you.
     
  2. kgeier82 macrumors 65816

    Joined:
    Feb 18, 2008
    #2
    I use sybase. You can also use terminal to connect to a oracle database, and go from there.

    How to do this, its been a while, I dont remember. Should start you somewhere.
    Of course, you need a database to connect to...something the professor should provide.
     
  3. Transporteur macrumors 68030

    Joined:
    Nov 30, 2008
    Location:
    UK
    #3
    In case that the provided server is an Oracle server, I recommend the Oracle SQL Developer.
     
  4. jc1350 macrumors 6502a

    Joined:
    Feb 4, 2008
    #4
    I use Navicat Lite (www.navicat.com). It's a great program and legally free for home/student use.

    They have an all-in-one for MySQL, Oracle, and Postgre SQL or you can use one dedicated to the type of DB you use (smaller install I guess is the benefit).
     

Share This Page