Differences

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

--- development:database:start [20 years ago - 2006/02/14 02:38] – aogail
+++ development:database:start [19 years ago - 2007/05/28 06:45] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== 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]].