Database Diagrams

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

Database Diagrams

Postby jfmccabe » Fri Jan 08, 2010 10:29 am

Is it possible to have an option to document database diagrams and have them as hyperlinks to text documentation?
J McCabe
CMIS Manager
East Norfolk College
jfmccabe
 
Posts: 2
Joined: Fri Feb 02, 2007 2:12 pm
Location: Gorleston, Norfolk

diagram would be great

Postby paul.price » Fri May 14, 2010 9:55 pm

I echo the idea of having a database diagram option. Currently I need to create my own outside of SQL Doc and then add it to what was generated. This also means that I can not automat my docs in a build job, since manual editing is required.
paul.price
 
Posts: 11
Joined: Wed Oct 25, 2006 11:14 pm

Postby David Atkinson » Sat May 15, 2010 11:33 am

Thanks for the request. This is something we're considering. What would you like to include on the diagram?

David Atkinson
Product Manager
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby jfmccabe » Mon May 17, 2010 8:05 am

Basically, the same as the sql diagram pane i.e. Table Name, field names, symbol for Priamry Key fields with the option to click on a table, relationship or field and be taken to its definition.
J McCabe
CMIS Manager
East Norfolk College
jfmccabe
 
Posts: 2
Joined: Fri Feb 02, 2007 2:12 pm
Location: Gorleston, Norfolk

Postby David Atkinson » Wed May 19, 2010 11:54 pm

Thanks for the clarification.

However, I'm a little confused about what this provide above and beyond the current SQL Doc documentation? We don't display in a diagram, but we have this information in tabular form.

David
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Data Diagrams

Postby rick.sheeley » Wed Sep 15, 2010 9:44 pm

Well, the most immediate thing they show is table relationships. You can these visually very quickly with the Diagram tool.

I was actually thinking that a great link would be to be able to merge the dependency tracker data with the documentor.....
Eric (Rick) Sheeley, Sr. SQL/Oracle DBA
Sacramento, CA Cell: 602.540.6750
\"Those are my principles, and if you don't like them... well, I have others.\" - Groucho Marx
rick.sheeley
 
Posts: 23
Joined: Thu Dec 21, 2006 5:42 pm
Location: Bay Area, CA

You can add my name to this request

Postby joshturley » Mon Nov 22, 2010 6:49 pm

Currently, I've been pasting images of the diagrams from SSMS into jpg files, then modifying the HTML files to create a tree entry just for database diagrams.

I'd like to have links to the respective db diagrams from inside each table, but any modifications I make inside the HTML to do this would just be overwritten the next time I generate documentation.

A lot of companies like to visualize the relationships between tables, since tools like Crystal Reports and Access have similar diagrams in their software to make joins in queries, etc. Having this laid out helps them visualize it.

I don't think SQL Doc needs it's own diagramming tool, since the one in SSMS is probably a good start. There are things I wish SSMS did, but that's something for the MSDN boards.
joshturley
 
Posts: 2
Joined: Thu Nov 04, 2010 1:34 am
Location: Phoenix, AZ


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests