How do I generate a detailed report of my databases?

Question

Earlier versions of Visual Studio TFS included Visio for Enterprise Architects that supported reverse engineering and detail report generation for Sql Server databases. This is no longer supported and Visio 2007 does not include this report generation capability (or even decent support for Sql Server 2008). So I am wondering, is this feature now gone forever? And, if so, does anyone have a recommendation on any tools or utilities that can provide it?

Answer 1

Hi Bill

Would you mind telling us what kind of reverse engineering and detail reports you want?

Thanks!

Figo Fei

MSDN Subscriber Support in Forum

If you have any feedback on our support, please contact [e-mail]

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Pretty much everything that was available in the Visio for Enterprise Architects reports, which could be substantial. Howeverj, at the very least, an assay of objects such as database name, tables, columns, column attributes, constraints, stored procedures, etc.... all in docx or pdf format.

Answer 3

The Data Dude product doesn't currently provide something like this. We're looking at doing a power tool that takes advantage of the new extensibility in VS 2010 to generate a report like this. You might take a look at the Entity Framework tools. They may have a reporting component. I don't know.

---

Duke Kamstra - Program Manager - VSTS Database Edition (Data Dude, DBPro)