Subject: | SQLServer DB schema diagram generation example please |
Date: | Tue, 19 Nov 2013 17:55:01 -0500 |
To: | bug-SQL-Translator [...] rt.cpan.org |
From: | Tong Sun <suntong [...] cpan.org> |
Hi,
Could you provide a sample code for DB schema diagram generation, and for
Ms SQLServer DB especially please?
All that I can find from the web on using SQL::Translator to generate DB
schema diagrams are,
http://pwnguin.net/generating-database-schema-with-sql-and-graphviz.html
http://nsaunders.wordpress.com/2009/01/11/easy-visualisation-of-database-schemas-using-sqlfairy/
However, they are all old-tech now and I hope the code would go from
SQL::Translator::Producer::SQLServer<http://search.cpan.org/dist/SQL-Translator/lib/SQL/Translator/Producer/SQLServer.pm>
or SQL::Translator::Generator::DDL::SQLServer<http://search.cpan.org/~frew/SQL-Translator-0.11018/lib/SQL/Translator/Generator/DDL/SQLServer.pm>
to SQL::Translator::Producer::GraphViz<http://search.cpan.org/dist/SQL-Translator/lib/SQL/Translator/Producer/GraphViz.pm>,
instead of relying on mysqldump (or SQLServer dump), if possible.
Thanks