Posted by: Deepesh Shah | September 29, 2006

New Tool for Rapid database documentation – Data Dictionary Creator

Check this new tool for Database Documentation

Summary

Data Dictionary Creator (DDC) is a simple
application which helps you document SQL Server databases. It stores
all the information in Extended Properties, so it’s easier to keep the
documentation in sync with the database as it changes. You could do a
lot of this through SSMS (SQL Server Management Studio), but

  1. It’s a lot more work, which means it’s a lot less likely to be kept updated.
  2. The
    SSMS approach only gives you one column (Description); DDC gives you as
    many as you want. That’s probably one of the best features DDC adds –
    it lets you tailor your documentation to your database and business.
  3. SSMS requires you to write your export via tricksy SQL; DDC exports to WordML, Excel, HTML, and XML.

You can download Data Dictionary Creator from the VelocIT tools site.

follow the link below for how to use it

Source : http://weblogs.asp.net/jgalloway/archive/2006/09/28/_5B00_Tool_5D00_-Data-Dictionary-Creator-_2D00_-Rapidly-database-documentation.aspx

Tags : SQL Tool, Database Documentation, .net tools

powered by performancing firefox

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: