Suggestion for enhancement

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

Suggestion for enhancement

Postby rcroeder » Tue Nov 03, 2009 9:49 pm

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
rcroeder
 
Posts: 5
Joined: Sat Aug 02, 2008 1:17 am

Postby Brian Donahue » Thu Nov 05, 2009 4:17 pm

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_Co ... dex_v2.htm
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

not exactly

Postby rcroeder » Thu Nov 05, 2009 6:40 pm

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
rcroeder
 
Posts: 5
Joined: Sat Aug 02, 2008 1:17 am

Postby Brian Donahue » Sat Nov 07, 2009 9:38 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests

cron