Data Dictionary Creator

Project Home Page
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.



Take a look at this DDC Walkthrough to see how easy it is to document your database.

Version 1.3.2 (08/10/09)

• Minor tweaks to existing xls templates (Column "schema" brought to first)
• Added 2 xls templates "Word Grouped" & "HTML Grouped"
• Preload all table information, this stops SMO from making unnecessary round trips, increasing performance

Version 1.3.1 (17/07/08)

• Fixed bug when adding existing additional properties

Version 1.3 (29/05/08)

• Schema/owner support. dbo.tblTest & core.tblTest will be handled as seperate tables
• Screen improvement. Window resizing will now stretch controls to take advantage of the available space
• Fixed bug when connection to SQL Server Express
• Export to SQL will now escape single quotes
• Start menu folder will no longer be named (Default)
• xls templates will display table schema/owner
• Other minor adjustements

Version 1.2 (11/14/06)

• Added documentation of tables as well as columns
• Changed Excel export from HTML based to XMLSpreadsheet to support separate worksheets for Table and Column documentation
• Improved error handling - detection of non-DBO logins, etc.
• (UI) - tab reorganization to fit workflow a little better
• (UI) - moved feedback and progress bars to statusbar for consistency
• Support for SQL 2000 and 2005 export scripts (there were several breaking changes from 2000 to 2005)
• Limited import functionality (SQL and XML)
• Added Installer

Version 1.1 (9/29/06)

• T-SQL export to allow copying documentation between database instances (thanks, Tyler!)
• Loads previously used additional properties from database on connection
• User interface enhancements
• Bug fixes