Free diagramming tool for SQL 2005?

edmicman

Golden Member
May 30, 2001
1,682
0
0
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!
 

KLin

Lifer
Feb 29, 2000
29,556
163
106
Have you tried using the Database Diagrams option under each database within SQL Management Studio?
 

edmicman

Golden Member
May 30, 2001
1,682
0
0
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!
 

KLin

Lifer
Feb 29, 2000
29,556
163
106
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.