anyway to generate a graph from sql code?

[jkresh]

I would like to show a graph (nodes and edges) from a sql database where each node is a table and has edges linking to elements of the table and there are different colored edges linking elements that reference each other. I know I could do it manually with graphviz or write a script to convert the table definitions to graphviz code but if there is a program that already does this it would save me some trouble. Any suggestions would be appreciated.

 

[KLin]

You need to have a front end application to show the data graphically. You can use excel, access, crystal reports, a custom app, etc. etc.

 

[mundane]

Someone already wrote the required script in Perl. Like this? http://sqlfairy.sourceforge.net/

Result returned from a google search for SQL + graphviz.

 

[AFB]

Yes, PHP

 

[kamper]

What kinda database? Enterprise Manager does a pretty decent job for SQL Server.

 

[jkresh]

the database is in mysql, sqlfairy seems to be perfect but doesnt want to run in windows and I dont have time at teh moment to set up linux on my dekstop and my notebook is not linux friendly (dell wireless card seems to be rather difficult to set up in ubuntu and redhat wont partition the drive (its partition manager wont even work with the 18gigs of free space) so it may not be a viable solution at the moment