Tag Your Database - A Data Dictionary Tool

A few days back Jon Galloway and I were discussing a task he was working on to document a database for a client.  He had planned to use some code generation to initially populate a spreadsheet and would fill in the details by hand.  I suggested he store the data with the schema using SQL extended properties.

We looked around and found some stored procs for pulling properties out, but no useful applications for putting them in there in a nice, quick, and easy manner.

A few days later, the freaking guy releases this Database Dictionary Creator, a nice GUI tool to document your database, storing the documentation as part of your database schema.

Database Dictionary Entry Form

The tool allows you to add your own custom properties to track, which then get displayed in the data dictionary form grid as seen above. Audit and Source are custom properties. It is a way to tag our database schema.

You ask the guy to build a house with playing cards and he comes back with the Taj Mahal.

Check it out.

What others have said

Requesting Gravatar... Srdjan Sep 28, 2006 12:29 PM
# re: Tag Your Database - A Data Dictionary Tool
nice form... WPF?
Requesting Gravatar... Haacked Sep 28, 2006 12:38 PM
# re: Tag Your Database - A Data Dictionary Tool
Nope, I think Jon used normal winforms. But he has a certain WinXP theme he's running.
Requesting Gravatar... Creative Minds Sep 29, 2006 5:38 AM
# Tag Your Database - A Data Dictionary Tool
Tag Your Database - A Data Dictionary Tool

What do you have to say?

(will show your gravatar)
Please add 4 and 8 and type the answer here: