Database reverse engineering

am Sat, dem 08.09.2007, um 11:44:17 +0200 mailte Thorsten Kraus folgendes:

Hello,

I am looking for a tool which is able to generate a database diagramm
including the relationships from an existing database schema. The only
tool I know for this purpose is the Clay database plugin for eclipse.
Are there any other tools which can help me?

Maybe this one:

postgresql-autodoc - utility to create system tables overview in HTML, DOT and XML

,----[ apt-cache show postgresql-autodoc ]
| Description: utility to create system tables overview in HTML, DOT and XML
| This is a utility which will run through PostgreSQL system tables and returns
| HTML, DOT, and 2 styles of XML which describes the database.
| .
| The HTML is human readable (via webbrowser). The first style of XML is actually
| the fileformat of Dia, a UML diagram tool. The second type of XML is similar to
| the HTML but in the Docbook 4 format. It enables you to mix in other docbook
| documentation via the XREFs, generating PDFs, HTML, RTF, or other formatted
| documents. Between these tools and JavaDoc with the appropriate XREFs,
| documentation about a project can be generated quickly and be easily updatable
| yet have a very professional look with some DSSSL work.
`----

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

On 9/8/07, Thorsten Kraus <TK-Spam@gmx.de> wrote:

Hello,

I am looking for a tool which is able to generate a database diagramm
including the relationships from an existing database schema. The only
tool I know for this purpose is the Clay database plugin for eclipse.
Are there any other tools which can help me?

toad database modeler and ems postgresql manager are both pretty good
(both commercial windows programs). honestly, I think generated web
pages with hyperlinks is much more useful than an ERD. so for free
tool I would start with autodoc, which is IMO pretty limited but a
good foundation for improvement perhaps?

merlin

Or this one:
http://schemaspy.sourceforge.net/

On Sep 8, 2007, at 4:43 AM, A. Kretschmer wrote:

On Sat, 08 Sep 2007 11:44:17 +0200
Thorsten Kraus <TK-Spam@gmx.de> wrote:

I am looking for a tool which is able to generate a database
diagramm including the relationships from an existing database
schema. The only tool I know for this purpose is the Clay database
plugin for eclipse. Are there any other tools which can help me?

DbVisualizer: http://www.dbvis.com/products/dbvis/

Cross platform - free version available but licensed one ($150) is
much more feature rich.

Here's a sample I reverse engineered today - a subset of the schema,
which was nice to be able to do:

http://www.smcing.com/images/pb_schema.jpg

Josh

On Mon, 2007-09-10 at 13:00 -0600, RC Gobeille wrote:

Or this one:
http://schemaspy.sourceforge.net/

Can't seem to get it to connect to PG using the example.

java -jar schemaSpy_3.1.1.jar -t pgsql -u operator -p operator -o
test_db -host localhost -db test_db
Using database properties:

[schemaSpy_3.1.1.jar]/net/sourceforge/schemaspy/dbTypes/pgsql.properties
java.lang.ClassNotFoundException: org.postgresql.Driver

Failed to load driver 'org.postgresql.Driver' from: []
This entry doesn't point to a valid file/directory:
[/whereever/postgresql-8.0-312.jdbc3.jar]

Use -t [databaseType] to specify what drivers to use or modify
one of the .properties from the jar, put it on your file
system and point to it with -t [databasePropertiesFile].

For many people it's easiest to use the -cp option to directly specify
where the database drivers exist (usually in a .jar or .zip/.Z).
Note that the -cp option must be specified after schemaSpy_3.1.1.jar

Embarcadero's tools are quite nice, quite pricey, Windows only.

--
Scott Ribe
scott_ribe@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice

On 13 Sep, 06:12, Ow.Mun.H...@wdc.com (Ow Mun Heng) wrote:

On Mon, 2007-09-10 at 13:00 -0600, RC Gobeille wrote:

Or this one:
http://schemaspy.sourceforge.net/

Can't seem to get it to connect to PG using the example.

java -jar schemaSpy_3.1.1.jar -t pgsql -u operator -p operator -o
test_db -host localhost -db test_db

As the end of the error message suggests, you might want to try
something like this:

java -jar schemaSpy_3.1.1.jar -cp postgresql-xxx.jar -t pgsql -u
operator -p operator -o test_db -host localhost -db test_db

The argument for -cp needs to be the full path to the .jar file, and
must obviously use the real filename of that file itself. You may then
get complaints about not finding the schema: I had to specify "-s
public", I think.

Paul