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:35] – aogaildevelopment:database:start [19 years ago - 2007/05/28 06:45] (current) – external edit 127.0.0.1
Line 7: Line 7:
 [[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 -jar schemaSpy_2.1.0.jar -t pgsql -o test -host localhost:1337 -db jansenbe -u jansenbe -p password -s assign3 -cp /usr/share/jdbc2-postgresql-6/lib/pg74.215.jdbc2.jar+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: Using database properties:
     [schemaSpy_2.1.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties     [schemaSpy_2.1.0.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
Line 18: Line 19:
 Wrote relationship details of 27 tables/views to directory 'test' in 71 seconds. Wrote relationship details of 27 tables/views to directory 'test' in 71 seconds.
 Start with test/index.html 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]].