Do you hate starting on a new project and having to try to figure out
someone else's idea of a database?
Or are you in QA and the developers expect you to understand all the
relationships in their schema?
If so then SchemaSpy is a great tool for you.
SchemaSpy is a Java-based tool (requires Java 5 or
higher<http://www.java.com/getjava/>\)
that analyzes the meta data of a schema in a
database and generates a visual representation of it in a
browser-displayable format. It lets you click through
the hierarchy of database tables via child and parent table relationships
as represented by both HTML links
and entity-relationship diagrams. It's also designed to help resolve the
obtuse errors that a database sometimes
gives related to failures due to constraints. It is free software that is
distributed under the terms of the <http://www.gnu.org/licenses/lgpl-2.1.html>
Lesser GNU Public License 2.1 <http://www.gnu.org/licenses/lgpl-2.1.html>\.
I tried to generate all the schema for DHIS2 data based which one can find
in the attachment given below.
Pls extract it from the zip file and click on index.html file which will
give you starting navigation for doing any
schema based analysis.
Looks nice. well it uses dot which is always nice. I think you
forgot an attachment ...
···
On 8 May 2012 11:41, Brajesh Murari <brajesh2murari@gmail.com> wrote:
Hello Devs,
Do you hate starting on a new project and having to try to figure out
someone else's idea of a database?
Or are you in QA and the developers expect you to understand all the
relationships in their schema?
If so then SchemaSpy is a great tool for you.
SchemaSpy is a Java-based tool (requires Java 5 or
higher<http://www.java.com/getjava/>\)
that analyzes the meta data of a schema in a
database and generates a visual representation of it in a
browser-displayable format. It lets you click through
the hierarchy of database tables via child and parent table relationships
as represented by both HTML links
and entity-relationship diagrams. It's also designed to help resolve the
obtuse errors that a database sometimes
gives related to failures due to constraints. It is free software that is
distributed under the terms of the <http://www.gnu.org/licenses/lgpl-2.1.html>
Lesser GNU Public License 2.1 <http://www.gnu.org/licenses/lgpl-2.1.html>\.
I tried to generate all the schema for DHIS2 data based which one can find
in the attachment given below.
Pls extract it from the zip file and click on index.html file which will
give you starting navigation for doing any
schema based analysis.