Home
Releases
Discussions
Issue Tracker
Source Code
Stats
People
License
RSS RSS Feed
Search Wiki:
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.

DDC_DocumentDbTab.png

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

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
Last edited Jul 18 at 2:49 AM  by Blade_316, version 11
Comments
tuangianglion wrote  Apr 23 2007 at 3:20 AM  
ok

retzel21 wrote  Jun 26 2007 at 7:34 AM  
I just Viewed Ur System and its awesome just want to add some comments about adding some features to ur system like not just the documentation of the database but also the monitoring of database's spaces (Total consumed, left, etc.). So DBA can easily document not only the database info but also document the space consumed by the database and transaction logs. By adding this kind of features ur system will be more helpfull to other DBA around the world. If you have time try to email me lpolicarpio2005@yahoo.com (first letter is small 'L') thnx in advance and looking 4ward to your email have a pleasant day.

acassel wrote  May 30 at 2:27 AM  
Absolutely fantastic project and effort!! SO needed. Thank you for your tremendous effort and willingness to share it with the community, really terrific! It's going to blow away my DBA team!

Updating...