Red Gate forums :: View topic - Database Diagrams
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 2
SQL Doc 2 forum

Database Diagrams

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
jfmccabe



Joined: 02 Feb 2007
Posts: 2
Location: Gorleston, Norfolk

PostPosted: Fri Jan 08, 2010 10:29 am    Post subject: Database Diagrams Reply with quote

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
Back to top
View user's profile Send private message
paul.price



Joined: 25 Oct 2006
Posts: 11

PostPosted: Fri May 14, 2010 9:55 pm    Post subject: diagram would be great Reply with quote

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.
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1113

PostPosted: Sat May 15, 2010 11:33 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
jfmccabe



Joined: 02 Feb 2007
Posts: 2
Location: Gorleston, Norfolk

PostPosted: Mon May 17, 2010 8:05 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1113

PostPosted: Wed May 19, 2010 11:54 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
rick.sheeley



Joined: 21 Dec 2006
Posts: 22
Location: Bay Area, CA

PostPosted: Wed Sep 15, 2010 9:44 pm    Post subject: Data Diagrams Reply with quote

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
Back to top
View user's profile Send private message Send e-mail MSN Messenger
joshturley



Joined: 04 Nov 2010
Posts: 2
Location: Phoenix, AZ

PostPosted: Mon Nov 22, 2010 6:49 pm    Post subject: You can add my name to this request Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group