Red Gate forums :: View topic - Suggestion For SQL Doc
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

Suggestion For SQL Doc

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
kirkkelly



Joined: 16 Aug 2005
Posts: 2

PostPosted: Thu Jan 21, 2010 5:45 pm    Post subject: Suggestion For SQL Doc Reply with quote

I'd like to see the following in a future release:

1. A Statistics section, that shows some basic counts:
Total Number of Tables.
Total Number of Stored Procedures / Functions
Total Lines of code in stored procedures

2. An enhanced "Front Page" that allows you to maybe include a logo
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Fri Jan 22, 2010 10:29 am    Post subject: Reply with quote

Thanks for your suggestions. Would you be able to tell us the reason why each of these statistics are important to you?

Would you want a logo to appear on all pages, or just the front page? If the latter, what else would be on the front page?

Regards,

David Atkinson
Product Manager
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
kirkkelly



Joined: 16 Aug 2005
Posts: 2

PostPosted: Fri Jan 22, 2010 11:28 pm    Post subject: Reasons Why Reply with quote

The overall reason is documenting not only the database, but the size and scope of the database (and basically the project it supports). This is probably not that overly important to others, but when looking at a database, it give a sense of the scope of the whole thing. Seeing the number of stored procedures give you a good idea right up front of how an application is addressing the database. Seeing of line count of those stored procedures shows up front how complex they are (or not).

Really just like the front page, being the introduction of the database, with maybe the statics being on this front page. There is another product called SqlSpec that does a nice job on the front page. It's a slow tool, and doesn't let you edit like yours, so right now I'm kinda of using both.
Back to top
View user's profile Send private message
keith_D



Joined: 25 Jan 2010
Posts: 2

PostPosted: Fri Jan 29, 2010 8:00 pm    Post subject: Counts Needed Throughout Reply with quote

I agree with kirk.

I dont know about you guys but I have been spending a lot of time adding descriptions to db objects in large dbs. I have to report my progress to my boss. It would be nice if when you expand any folder in the database object tree it showed number of nodes. Then I could easliy see how many sprocs, for example I am working with. This is a useful indicator for estimating time needed to document.
Back to top
View user's profile Send private message
Cowski



Joined: 18 Dec 2009
Posts: 12

PostPosted: Wed Mar 17, 2010 5:31 pm    Post subject: Agree with Kirk... Reply with quote

Kirkkelly has some very good suggestions!

My additions to this are:

1. Search feature with the potential of a wildcard search. Example if we're looking for a certain sproc...type it in the search & it will return a web page with every location this sproc is located in.

2. The ability to edit descriptions for tables, views, etc. with the capability of the updated description to be added back to the database.

3. A quick refresh for descriptions for example. So if something was recently changed in SSMS you can refresh that particular page to show your update without rerunning then entire SQL Doc for that server when only 1 small change was made.

4. Along those lines, for reporting purposes only, a editable section for nearly every page.

This is just a start. Overall I am 100% TOTALLY blown away by this product! It takes a lot to impress me nowadays with software after being in the industry for over 25 years. This software thoroughly impresses me!! Keep up the great work, Red-Gate!!
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1121
Location: Twitter: @dtabase

PostPosted: Wed Apr 07, 2010 1:27 pm    Post subject: Reply with quote

Thanks for the ideas.

It's worth mentioning that SQL Doc *does* let you change the Descriptions. If you click on the pencil icon in the preview pane it pops up a dialog in which you can edit the description.

With regards to point 4, would you like the editable section to write back to the database, or should this be stored in SQL Doc's own project file?

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