SQL database Diagrams

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • johnsocb
    New Member
    • Nov 2006
    • 2
    #1

    SQL database Diagrams

    Pretty new to SQL, but I have had the good luck to be responsible for documenting a very sophisticated program that is a .net application. Anyhow the SQL side of the app is NOT documented with the database diagrams in SQL enterprise manager or with anything else for that matter.

    I am not sure how this person setup the relationships/ primary key / foreign keys for these tables , but they appear to have none. How does one untangle the system and use database diagrams (or other tool) to get this system documented?

    Any help from the experts is really really appreciated.
    Thanks
    Curt
    Tags: None
    • vssp
      Contributor
      • Jul 2006
      • 268
      #2
      Visiyo software is helpfull to develop the database diagram

      vssp

        Comment

        • darkdirk1
          New Member
          • Oct 2006
          • 50
          #3
          visio is nice but the way to go is undoubtedly MicroOlap.
          Believe you me - i have designed schemas w/ both and the latter is hugely more intuitive.


          Also, though I have never done it, (im pretty sure) if you add your database to Visual Studio 2005 it can spit a diagram out for you - w/out the need to fill in any details.

            Comment

            Previous template Next
            Working...