Red Gate forums :: View topic - My suggestions for SQL Doc 2.0
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

My suggestions for SQL Doc 2.0

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
Cowski



Joined: 18 Dec 2009
Posts: 12

PostPosted: Wed Mar 17, 2010 5:33 pm    Post subject: My suggestions for SQL Doc 2.0 Reply with quote

I posted this same info under another forum message but thought I'd start my own to see what happens.

My suggestions to SQL Doc 2.0 would be these:

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
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Fri Mar 19, 2010 1:44 pm    Post subject: Reply with quote

Thanks for your suggestions.

Quote:
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.


I've logged this suggestion for consideration in a future version of SQL Doc (SDOC-1423). However, you might find that using Red Gate SQL Search in SSMS already does a pretty good job of this, and it's free!

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


This is currently supported in the UI. See here
Or would you like to make actual structural changes to the objects through SQL Doc?

Quote:
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.


I'm not sure this will be possible, as SQL Doc will need to interrogate the entire schema to make sure the dependencies are correct. Would it help if your project was split per database rather then the whole server? You could then just run the documentation for that database. Alternatively, you could use the command line interface to automate the generation of the documentation.

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


There is MS_Description for each object, or are you looking for something else?

I hope this helps.
_________________
Chris
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