I finally finished the next iteration of MSSqlSchemaDoc by adding a facility for the user to add custom comments and notes to document the database objects.
The application creates objects documenting the structure of each database object (as per version 1), but will now also generate blank templates (separate from the schema) where user comments can be added. Comments are also preserved when re-generating.
The reason for keeping the user comments separate from the schema documentation is so that source control and versioning can run independently between schema changes and documentation changes. When looking for a schema change in a commit log, I sure don't want to have to trawl through all the comment changes!
Why not check it out and let me know what you think?
posted @ Thursday, November 13, 2008 2:59 PM