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:

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&nbsp; -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 appear here based on the labels you select. Click to edit the macro and add or change labels.

truemodified5database datamodel analyse diagramfalsepage