====== Database ======

===== Diagramming =====

==== SchemaSpy ====

[[http://schemaspy.sf.net/|SchemaSpy]] is an awesome tool for database schema reporting.

<code>
aogail@aleath ~ $ java -cp /usr/share/jdbc2-postgresql-6/lib/pg74.215.jdbc2.jar -jar schemaSpy_2.1.0.jar \
-t pgsql -o test -host localhost:1337 -db jansenbe -u jansenbe -p password -s assign3
Using database properties:
    [schemaSpy_2.1.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Connected to PostgreSQL - 8.0.3

Gathering schema details...........................(14sec)
Writing/graphing summary...........(7sec)
Writing/graphing results...........................(49sec)
Wrote relationship details of 27 tables/views to directory 'test' in 71 seconds.
Start with test/index.html
</code>

===== PostgreSQL =====

HOWTO for [[http://techdocs.postgresql.org/techdocs/sqlserver2pgsql.php|converting from MSSQL to Postgres]].