We all have our favorite database structure generator or schema reporting tool. Maybe we have built one of them in the past. I always tell my clients that it’s a great “first application” to build when learning SQL Management Objects (SMO).
I just found out about SqlSpec.
SqlSpec generates documentation in two formats: HTML or CHM. I particularly like the CHM format, especially when you want a single, compact file containing all your documentation about one or more databases. The CHM is indexed so it is easily searchable for any keyword. If you visit their Samples page, you can see what these CHM files look like.
Naturally, SqlSpec supports SQL Server and Analysis Services, but also other legacy databases like Oracle, MySQL, and Access. It’s $149 and they have a free trial version.
Pretty slick.