Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
development:database:start [20 years ago - 2006/02/14 02:24] – aogaildevelopment:database:start [19 years ago - 2007/05/28 06:45] (current) – external edit 127.0.0.1
Line 6: Line 6:
  
 [[http://schemaspy.sf.net/|SchemaSpy]] is an awesome tool for database schema reporting. [[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 ===== ===== PostgreSQL =====
  
 HOWTO for [[http://techdocs.postgresql.org/techdocs/sqlserver2pgsql.php|converting from MSSQL to Postgres]]. HOWTO for [[http://techdocs.postgresql.org/techdocs/sqlserver2pgsql.php|converting from MSSQL to Postgres]].