ApexSQL Doc
I use this product and it's pretty good. It struggles sometimes with dealing with multiple servers but you can break those down to more manageable jobs so that it does not error during processing. On the whole, its a great piece of software which describes and documents your databases using the extended properties as the descriptors.
Tip: It's a very good idea when using SQL Server Extended Properties to decide what you are going to use use as a label i.e. 'MS_Description' and then use this label all the way through your descriptions for Tables, Fields etc. The reason for this is that Apex SQL Doc can only use one label so if you have different labels sprinkled throughout your database you won't see them all when you carry out your database documentation.
Your database Visualised. Database to documentation in a variety of formats.
Generate database and SSIS documentation in CHM, HTML and Word
Automate and schedule the documenting process
Include relationship diagrams in your database documentation
Leverage extended properties and edit them directly
More information: http://www.apexsql.com/sql_tools_doc.aspx
No comments:
Post a Comment