Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Database Documentation / Design Illustration Tool

Options
  • 10-08-2012 8:04pm
    #1
    Cork Skate
    Registered Users Posts: 884 ✭✭✭


    Folks,

    Just want to ask if there is any good tool/application out there to manage database tables and all of their attributes. Not building them, just to display whats what in a graphical form, similar to Visio -> 'Database Model Diagram' but with a bit more to it, i just want to put in more detail.

    Any ideas?


Comments

  • Options
    #2
    Tom Dunne
    Registered Users Posts: 23,212 ✭✭✭✭Tom Dunne


    I'm not aware of any that do it in graphical form (but that's not to say none exist), but some management tools will generate a diagram from a schema.

    What DBMS?


  • Options
    #3
    croo
    Moderators, Technology & Internet Moderators Posts: 1,334 Mod ✭✭✭✭croo


    It's been a while since I looked but last time I did I found
    http://www.aquafold.com/aquadatastudio.html
    Will do what you asked. I believe if you work on an open source project you can get free license keys... at least we did on the Adempiere ERP project.
    There might be a limited/trial version to download if your needs are short term.

    If you only wanted to create a ERD image then I believe SchemaSpy (available on Sourceforge) can read most database schema to create the model.
    http://schemaspy.sourceforge.net/sample/relationships.html

    I've not looked recently but I'd be amazed if there is not some plugin (or combination of plugins) for the eclipse IDE that would also provide such functonality.

    As Tom asked - which DB might have a big bearing on the options


  • Options
    #4
    DublinWriter
    Registered Users Posts: 9,557 ✭✭✭DublinWriter


    Both Sybase PowerDesigner and IBM Rational Rose are pretty good.


Advertisement