Auto Generate Data Dictionary From SQL Database

Data Dictionary Creator is a simple, free tool that helped me immensely with SQL Server database documentation.

It stores all the information in Extended Properties, so it’s easier to keep the documentation in sync with the database as it changes. I was able to generate a data dictionary with just a couple of mouse clicks after entering the connection string. The dictionary can be exported to various formats: Excel, XML, Word, and HTML. Check the reference for a step-by-step tutorial on using this utility (the current version supports SQL Server 2008 too). You can download it from CodePlex.