Building ER-Diagram using Schema Spy

==> make sure you have java installed
#cd /etc/yum.repos.d/

# wget http://www.graphviz.org/graphviz-rhel.repo

el –> enterprise linux
#yum localinstall graphviz-2.26.3-1.el5.x86_64.rpm –nogpgcheck

download ScheamSpy_5.0.0.jar https://docs.google.com/leaf?id=0B7-_8Og_7Y2YOTIyZGFiNjUtYjIwMy00MTA4LTlmZDgtMmYzZDJjNWI5YmM5&hl=en&authkey=CJTr2okE

and postgresql-8.4-701.jdbc3.jar

https://docs.google.com/leaf?id=0B7-_8Og_7Y2YZGFiMTBmZDItMDIzYi00MWUyLWE1NDctMTJiZjRlZDk4ZDRl&hl=en&authkey=CIG3isYN

you need to have schemaSpy_5.0.0.jar and the postgresql driver

#java -jar schemaSpy_5.0.0.jar -t pgsql -dp /users/dmurthy/postgresql-8.4-701.jdbc3.jar -host localhost -u postgres -db v4 -s public -o schema_spy_op

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s