469,644 Members | 1,774 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,644 developers. It's quick & easy.

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.
Nov 9 '06 #1
2 1708
268 100+
Visiyo software is helpfull to develop the database diagram

Nov 10 '06 #2
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.
Nov 10 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Peter Ellis | last post: by
1 post views Thread by Tim Pascoe | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.