SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Dictionary


Database Dictionary

Author
Message
river1
river1
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4310 Visits: 1366
Hi,

Some company asked for the database dictionary. I have to give them that information but i am not choore of what that is. Is there any tool that can generate such information?


Thank you.
SanjayAttray
SanjayAttray
SSCertifiable
SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)SSCertifiable (5.6K reputation)

Group: General Forum Members
Points: 5639 Visits: 1619
Is it this, that you are looking for?

http://www.mssqltips.com/tip.asp?tip=1499
http://www.mssqltips.com/tip.asp?tip=1619

SQL DBA.
river1
river1
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4310 Visits: 1366
Thank you very much for the links.

I have read them (the links) and now i know what a database dictionary is...

But i still have a problem , i do not have created the extended properties in the tables when i designed the database...

Isn't there a tool or a way in SQL Server to create a script that fills this extended properties with the information about the tables and the column in it, so i can then generate the dictionary?

My extended properties are in blank (no informaiton)

I have Erwin 7.1 , visio 7 and management studio as tools. Does any of this tools can generate information so i can then receive the datadicionary?


Thank you.
mar1jxm
mar1jxm
SSC Veteran
SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)SSC Veteran (236 reputation)

Group: General Forum Members
Points: 236 Visits: 656
In my opinion the BI Documenter 4.0 - is the best!

Try this: http://www.pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Default.aspx



BI Documenter outputs "MSDN style" SQL Server documentation in either compiled help or HTML format. While documenting all of the major SQL Server components, BI Documenter also documents the entire BI stack, including Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).The unique documentation snapshot feature enables archiving of historical SQL Server documentation sets. New documents can be regenerated at the touch of a button. BI Documenter also allows you to customize the look and feel of your documentation with the ability to add your own branding.


With BI Documenter, you can:
Generate complete SQL documentation at the push of a button
Document SQL Server, Analysis Services, Integration Services and Reporting Services in the same documentation set
Capture metadata snapshots for historical analysis
Output HTML Help (*.chm) or plain HTML
Use either a graphical wizard or command line interface
Document SQL Server 2008!
Tell your own story using the built-in diagramming tool
New Features of BI Documenter:
Compare Snapshots
Object Lineage/Impact Analysis
Snapshot Object filtering
Data Profiling and Recommendations
Diagram Editor Object Properties
Snapshot Creation



Also included are a host of UI and usability enhancements to increase user productivity.
Review Your Solution: page provides a tool tab navigate to key functionality instead of having to click the next button reach those features.
Snapshot Creation: exception link is provided to display a dialog to display any exceptions that were encountered during.
UI look and feel: Updated to coincide with UI look and feel like other product offerings.


Jacob Milter
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search