Generating database diagrams for schema analysis

If you want to analyse a database, understand relations between its tables etc., you can use this tool : schemaspy

Example usage:

Creating openerp database diagrams

1. Download schemaspy from : http://sourceforge.net/projects/schemaspy/files/
2. It used to have dependency on Graphviz, so you may also have to install graphviz : http://www.graphviz.org/Download..php
3. command to execute the jar :
   

   java -jar schemaSpy_5.0.0.jar -t pgsql  -db openerp -s public -u openerp -p <password> -host <host> -o <output dir> -dp <path-to-the-db-driver>

More info on the parameters can be found at http://schemaspy.sourceforge.net/

Related articles

• Page:
  Modeling Patient & Clinical Data in Bahmni (Training)
• Page:
  Generating database diagrams for schema analysis