Tool for creating diagrams of stored procedures

[adeveloper]

Hi,

When you have a lot of stored procedures it seems like being able to produce
a diagram showing the dependencies/relationships would be one of the best
ways of documenting them. It would give an immediate overview of the code
and make it much easier to understand. Ideally I think you could expand
component diagrams to see individual DB objects (SPs and tables) which where
part of a component.
I am frustrated that Visio does not support this - you really want something
that can be linked to the actual DB (reverse engineer whatever).

Some tools that people have recommended are: ErStudio, PowerDesigner and SQL
Source Control (http://www.sqlsourcecontrol.com/sqlsourcecontrol.htm). I am
just a bit concerned about getting tied into a particular tool. Has anyone
had experience of these tools?

Thanks
Pete

 

[Ron Hagerman]

I use Visio 2000 Professional. You have to be careful because not all
versions of Visio 2000 has the database model. (Enterprise addition for one)

The professional edition allows me to reverse engineer the database, stored
procedures, views, dependencies, etc. in SQL Server, Oracle or anything else
that I can create an ODBC connection to.