• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Free diagramming tool for SQL 2005?

E

edmicman

Golden Member
Is there something about there, free preferably, that would let you point to a SQL 2005 database and diagram and print out the table structures, stored procedures, etc.? I've got Visio 2003 Pro and it's saying the driver isn't compatible with my database. I just want a simple printout or something.....but I'm not sure what's out there. Thanks!
 
Have you tried using the Database Diagrams option under each database within SQL Management Studio?
 
I've played with it some; it still seems to only do tables and doesn't seem as robust as I'd like. I'm playing with Visio 2003 some more...turns out I can "force" it to work sort of using an ODBC driver to get the diagram, but it doesn't fully document the tables and doesn't touch stored procs. I found another shareware app which generates HTML for the whole thing, which is good, but it's broken up into a billion web files. Not really something I could print and hand out at a meeting initially. I'm still poking around, though....thanks for the help!
 
The only other way that I can think of is to generate a SQL script(right click database, click all tasks, click General SQL script), then choose the objects you wish to script into a file. that will get you the stored procedures.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top