Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Database relationship tool needed

  1. Aug 24, 2010 #1

    Borg

    User Avatar
    Science Advisor
    Gold Member
    2017 Award

    I just got handed an assignment to document our database tables. I would rather not have to do this manually and I'm wondering if anyone knows of any freeware that will allow me to create diagrams of the tables and relationships between the tables.
     
  2. jcsd
  3. Aug 24, 2010 #2

    Math Is Hard

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    Which RDBMS do you use? A trial version of Erwin might do everything that you need.
     
    Last edited: Aug 24, 2010
  4. Aug 24, 2010 #3

    Borg

    User Avatar
    Science Advisor
    Gold Member
    2017 Award

    Thanks MIH, I'll look into it. We're using a Sybase database. I've already written a quick program to pull all of the needed column info for each of the tables. Except for the definitions, that will kill an entire appendix.
     
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook