September 19, 2006 at 2:06 pm
Two questions for you all...
1. Has anyone found a good software that does database documentation that is fairly priced and pretty much fully automatic. Something to document tables,views,stored procedures and so on...
2. Have any of you found a paper or better yet a chart that shows what is new to sql server 2005 that wasn't in 2000 and also more importantly what was available in 2000 that will not be supported in 2005?
Thanks
September 19, 2006 at 4:51 pm
start:
Top 10 new features in SQL Server 2005
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1137301,00.html
September 20, 2006 at 7:47 am
SchemaToDoc for SQL Server (http://www.schematodoc.com) is reasonably priced ($95) and handles SQL Server 2000 and SQL Server 2005 databases. It's output is a Word document that includes primary keys, fields (datatype, size, nullable, defaults), indexes, check constraints, foreign key constraints, triggers, stored procedures, and views. It also lets you annotate your tables and fields (stored as extended properties) and includes those comments in the final Word document.
September 20, 2006 at 8:56 am
We are fans of DB Documentor, which produces a nice compiled Help file (.chm) that opens on any Windows box, or an HTML output file viewable in a browser. $199.
(http://www.elzaris.com/products/dbdocumentor/overview.aspx )
January 8, 2007 at 12:20 am
Sorry to bump this one but I couldn't resist.
SqlSpec is cheaper and better than any of these. plus it does several other RDBMS besides SQL Server.
---------------------------------------
elsasoft.org
January 26, 2007 at 2:56 pm
db documentor is a decent tool but if you have a large number of objects with dependencies (i.e. table is referenced by a big number of foreign key constraints ) in you database - the tool will abort with :
the connection was lost during the generation process error.
January 29, 2007 at 9:45 pm
Since this was Bumped I thought i'd add my Favorite Documenting tool
http://www.bidocumenter.com/Public/Default.aspx
my favorite part of this tool is that it documents SQL Server 2000,SQL Server 2005, Analysis Services 2005, Integration Services 2005 and Reporting Services AND ALL in the same documentation set!!
BRILLIANT and reasonably priced @199 single user and cheaper for bulk....
And the guys on the site are the guys creating the product so any issues they are right on top of it...
January 30, 2007 at 3:41 pm
If you have 1000 databases use a tool for 500 or less I have used Excel assuming all SQL Server are on the same network and tools like Embarcadero or Mom help so you can check detailed info about each database. It included one Oracle 9i and DB2 AS 400. Hope this helps.
Kind regards,
Gift Peddie
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply