Red Gate forums :: View topic - Suggestion for enhancement
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 enhancement

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
rcroeder



Joined: 02 Aug 2008
Posts: 5

PostPosted: Tue Nov 03, 2009 9:49 pm    Post subject: Suggestion for enhancement Reply with quote

The product works nice, however it could be enhanced. The program could point to a second database that contain the structure of the database being document, in such a format similar to syscolumns but with additional fields to handled notes regarding the field and tables. When SQL Doc runs it will update the SQL database by adding new fields, and marking fields that are deprecated. The output from SQL Doc would include the “Extra” data. A simple query could be added to see new tables and fields that need to be updated and fields that have been deprecated.
_________________
rc roeder
Back to top
View user's profile Send private message Send e-mail
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Thu Nov 05, 2009 4:17 pm    Post subject: Reply with quote

Hello Bob,

Thanks for the suggestion, but it sounds like the sort of thing you can already do with SQL Compare:
http://www.red-gate.com/products/SQL_Compare/index_v2.htm
Back to top
View user's profile Send private message
rcroeder



Joined: 02 Aug 2008
Posts: 5

PostPosted: Thu Nov 05, 2009 6:40 pm    Post subject: not exactly Reply with quote

Brian,

Not really, the SQL DOC is a method to provide documentation table. What I am suggesting is to tie that documentation to a database just for database documentation where the database can be further documented. If you look at the output from SQL Doc it gives you the structure of each table, but detail information regarding the usage or meaning of each field is missing.

As an example for table __ApplicationGroupToGroupAreaSite I may want to add additional documentation

[ApplicationGroupToGroupAreaSiteID] [int]
[ApplicationGroupID] [int]
[ApplicationGroupAreaID] [int]
[ApplicationLicenseSubTypeID] [int]
[ApplicationLicenseTypeID] [int]
[SiteTypeID] [int] What type of site is being displayed see table _applicationSiteType
[DisplayOrder] [int]
[StatusID] [int]
[AgencyID] [int] Current agency being rendered
[AppRefGUID] [uniqueidentifier]
[Side] [int] Determines the side of the form to draw the element, 0=left 1=right
_________________
rc roeder
Back to top
View user's profile Send private message Send e-mail
Brian Donahue



Joined: 23 Aug 2004
Posts: 6580

PostPosted: Sat Nov 07, 2009 9:38 pm    Post subject: Reply with quote

Hello Bob,

SQL Doc has the ability to add a "description" to a table column. Click the "Description" button next to the column and type in a description. This will add a SQL Server Extended Property to the column, which will persist in the database and can even be viewed outside of SQL Doc via SQL Server's fn_listextendedproperties function.
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