Re: [GENERAL] Database reverse engineering
I am trying to use postgresql-autodoc. The autodoc finds all the Perl modules and compiles but when I go to /usr/local/bin and run postgresql_autodoc like this I had a good luck with schema-spy (done in java)... http://schemaspy.sourceforge.net/ Vlad ps: the command I use is (all on one line): java -jar ~/app/schemaspy/schemaSpy_3.1.1.jar -t pgsql -cp /usr/share/java/postgresql-8.2-506.jdbc3.jar -host localhost -db database_name -s public -u database_user -o doc/db -cp - the location of postgresql jdbc driver -o - output directory The database_user does not need password for localhost connection to postgresql on my system... ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [GENERAL] Database reverse engineering
I am trying to use postgresql-autodoc. The autodoc finds all the Perl modules and compiles but when I go to /usr/local/bin and run postgresql_autodoc like this postgresql_autodoc -f owl -d owl -u postgres --password='' I get a message that says Use of uninitialized value in numeric lt () at /usr/local/bin/postgresql_autodoc line 246. PostgerSQL 7.3 and later are supported at /usr/local/bin/postgresql_autodoc line 247. Database handle destroyed without explicit disconnect. This happens when I run the program as root or as super user postgres. The postgresql on my Redhat 9 system is 8.2.5 . The 7.3 was removed with an RPM uninstall several weeks ago. The perl is 5.8.8. I do not know Perl. I have seen this list discuss using postgresql_autodoc so any help from people who have used this program would be appreciated. Please reply to me as well as the list as I am on the digest version. TIA. *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297 This e-mail message and any attachment(s) are for the sole use of the intended recipient(s) and may contain proprietary and/or confidential information which may be privileged or otherwise protected from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient(s), please contact the sender by reply email and destroy the original message and any copies of the message as well as any attachment(s) to the original message.
Re: [GENERAL] Database reverse engineering
On 13 Sep, 06:12, [EMAIL PROTECTED] (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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Database reverse engineering
Embarcadero's tools are quite nice, quite pricey, Windows only. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [GENERAL] Database reverse engineering
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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [GENERAL] Database reverse engineering
Or this one: http://schemaspy.sourceforge.net/ On Sep 8, 2007, at 4:43 AM, A. Kretschmer wrote: 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
Re: [GENERAL] 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 ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] Database reverse engineering
On 9/8/07, Thorsten Kraus [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
