Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Posts
    25

    Unanswered: Tool for ER Diagram

    Can some one suggest me good software to get the ER Diagram of a Mysql database? I mean I need to draw the db's table, fields and its dettails.

    Tks

  2. #2
    Join Date
    Nov 2003
    Posts
    91
    If you have access to a Windows box you could
    start us MS Access and link in the MySQL tables via ODBC
    and then use Access's "Relationships" window to draw
    the ERD.

    If you install MySQL on a Windows box the ODBC driver is
    automatically installed for you, and (I don't know how this
    is done!) MySQL databases created on the same machine
    are automatically given ODBC DSNs (Data Source Names)
    so that linking to them is very easy.

  3. #3
    Join Date
    Jan 2004
    Posts
    31
    AdoAnywhere has some support for drawing tbales and fields.

    www.adoanywhere.com

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    vanekl, maybe your windows box came with access, but it is not a standard part of the OS...

    smartcard, have a look at these data modelling tools

    i've heard others mention the Fab4 product (haven't tried it myself, though)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jan 2004
    Location
    Australia
    Posts
    42

    Arrow

    How do I link MS Access to the ODBC MySQL ?
    Can you details the steps please ?

  6. #6
    Join Date
    Nov 2003
    Posts
    91
    [Access Version 10.4302 2002]

    Create a database in Access.
    Select menu:
    File -> Get External Data -> Link Tables...

    The 'Link' dialog box will pop up. Choose 'Files of type' ODBC
    Databases. The 'Select Data Source' dialog box pops up.
    Click on the 'Machine Data Source' tab.
    In the 'Data Source Name' column you may see the name
    of your MySQL database if the MySQL database is on the
    same machine. If you don't see it, you can click on 'New'
    and add it. Click 'OK', so that the 'Link Tables' dialog box
    pops up next. Click on all of the tables you want to link into
    Access, and click the 'OK' button.
    You should then see your new table(s) listed in the 'Tables'
    view in Access.

    To create the ERD, select menu item:
    Tools -> Relationships...

    You can add tables to the 'Relationships' window by
    dragging tables from the main Access database window.
    Double-clicking in the Relationships window will allow you to
    add a constraint relationship between tables.

  7. #7
    Join Date
    Oct 2003
    Posts
    10

    ER/Studio

    Take a look at Embarcadero's ER/Studio.

    http://www.embarcadero.com/products/erstudio/index.html

  8. #8
    Join Date
    Jan 2004
    Posts
    24
    PHPMyAdmin guess that isn't graphical though. DB Designer 4 is pretty good. And it works very well with MySQL.

    Donny
    http://www.phpscripts.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •