StrataFrame Forum » StrataFrame Database Deployment Toolkit » Enhancement Requests » Report Documenting Table Structures

Report Documenting Table Structures

Charles R Hankey — Tue, 03 Jun 2008 09:09:57 GMT

Is there already a reporting function in DDT to print out the table structures etc? Or is there such an ability built into SQL Server 2005 someplace?

Just realized I have all kinds of documenting tools for my DBCs in VFP but don't know (or have forgotten) how to go about this in DDT/SQL

( If none of this is already there, consider reporting an ER for the DDT)

RE: Report Documenting Table Structures

Trent L. Taylor — Tue, 03 Jun 2008 09:09:57 GMT

We have used Redgates SQL Doc as well and all of their products are good. I guess the reason that the DDT doesn't have the ability to print is because there has been little to no requests for it...including from ourselves. We used to print these out when in VFP and using Stonefield...and you kindof had to since it was next to impossible to keep Stonefield up while programming. Another problem was keeping the print outs up to date.

But with the DDT we just bring up the DDT while programming. So it has not spawned a great need here...though there are some needs when supplying structures to 3rd parties, etc (or even help docs). So this is already on the list...if you have loaded the latest 1.6.6 beta, you will see that many changes are already in the works. ;)

RE: Report Documenting Table Structures

Bill Cunnien — Tue, 03 Jun 2008 07:29:18 GMT

I was quite impressed with RedGate's product, SQL Doc.

http://www.red-gate.com/products/SQL_Doc/index.htm

It is a little bit more money, but it can be bundled with other of their software to round out some of the functionality that a DBA might be needing.

I know this is an afterthought for you, but others who search the forums may find this helpful.

:)
Bill

RE: Report Documenting Table Structures

Charles R Hankey — Mon, 02 Jun 2008 22:49:38 GMT

They have a bundle for $100 that includes the .NET and ASP documentation tools and the SQL Server doc tool. Seemed reasonable so I bought it. :D

RE: Report Documenting Table Structures

Charles R Hankey — Mon, 02 Jun 2008 22:30:46 GMT

Ok, still think it would be nice to have a report of what DDT has stored (though after searching here and reading Trent's post on the subject maybe it wouldn't be that big a deal)

But my real issue was : How do you document a SQL Server database. Found this, it is only $50 and seems to do the job very well. Free trial download so I'd be interested to hear what others think.

http://www.winnershtriangle.com/w/Products.SQLDocumentationTool.asp