April 21, 2008 at 12:14 pm
What tools have you used to document SQL databases? I found this tool online:
http://www.winnershtriangle.com/w/Products.SQLServerDocumentationTool.asp
Has anyone used this SQL Documentation Tool from http://www.winnershtriangle.com/?
Do you have any other suggestions?
April 21, 2008 at 10:02 pm
Red Gate has SQL Doc( I work for them)
ApexSQL has something as well.
April 23, 2008 at 11:16 am
May be you can check HyperSql (http://sourceforge.net/projects/hypersql/) which is OpenSource.
April 23, 2008 at 11:44 am
Mark.
C.G
April 23, 2008 at 1:21 pm
we use RedGate as well.
¤ §unshine ¤
April 23, 2008 at 1:48 pm
BI Documenter is nice because it works for databases, SSASm SSIS, and SSRS (Enterprise).
If you are interested in a modeling tool Erwin is nice.
April 24, 2008 at 1:03 am
I wrote one that works for 11 different DBMS, SQL Server included of course.
see link in my sig for details.
---------------------------------------
elsasoft.org
April 25, 2008 at 7:35 am
Red Gate's nice but the last time I took at look it documented at the DB level and not at the Instance Level, thereby leaving out some pretty important information that I felt was not acceptable.
I chose ApexSQL Doc because it supported instance level documentation, command line support, and highly customizable output.
If you want to try a free solution have a look at SYDI: http://sydiproject.com/
April 25, 2008 at 8:13 am
You might want to check out SchemaToDoc (http://www.schematodoc.com). It generates Word and HTML output. Besides documenting your database it also has an interface that lets you easily annotate your tables, fields, and views. Your annotations are stored as extended properties and can be included in your output.
May 2, 2011 at 11:52 am
Here is one more Free Tool to document Sql Server Database
May 3, 2011 at 7:31 am
Here's another free option and i've used it many times: pretty good!
http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx
March 7, 2012 at 10:55 am
You could try LiveDoco - it's not a traditional documentation generator but rather a browser based tool one could use for example to explore a SQL Server DB and document it in the process. It uses INFORMATION_SCHEMA and system views to generate web pages on the fly and SQL Server's Extended Proprieties facility to store descriptions/notes.
By default it uses MS_Description, but you can create custom tags just as easily.
There is a search facility that allows searching object names (tables, views, columns, function/procedure parameters etc) and their descriptions.
And finally there is an export tool you could use to export your descriptions to a sql file that can be used to add/update descriptions in another DB or export your DB metadata to XML.
There is a read only online demo here (so you won't be able to save changes in the demo db).
Use the SSC2012 coupon code to get a 40% promotional discount for SQL Server Central members.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply