[postgis-users] Data modeling tool

[Van Bakergem, William]

Steve,

There is an excellent tool for ERD, SQL script and an Excel spreadsheet report.
Jude Professional
http://jude.change-vision.com/jude-web/product/professional.html

The graphics are much better than DB Designer.  
There's a $40 educational timed license (1 year).
Many other tools as well - sequence diagrams, class diagrams, mind maps, etc.

Davis van Bakergem


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Alexander Von Luenen
Sent: Tue 6/30/2009 10:40 AM
To: martin.fafard at geoprojection.com; postgis-users-bounces at postgis.refractions.net
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] Data modeling tool
 
Steve,

there is a nice tool out there developed by MicroOLAP
(http://www.microolap.com/), the Database Designer for PostgreSQL,
which lets you draw ERM diagrams and then generates the database from
that diagram. There's a free trial version on their webpage. This tool
is also capable of reverse-engineering databases.

There is also a tool called PostGeoOLAP, but I haven't tried it yet.
http://postgeoolap.projects.postgresql.org/ingles/release.html 

Cheers,
Alex



Dr Alexander von Luenen
Senior Research Associate
Great Britain Historical GIS
Dept. of Geography
University of Portsmouth
Buckingham Building, Lion Terrace
Portsmouth, PO1 3HE, UK
tel: +44-(0)23-9284-2500
fax: +44-(0)23-9284-2512


>>> <Steve.Toutant at inspq.qc.ca> 30/06/2009 16:19 >>>
Thanks Martin,
I'm already using pgAdminIII to manually manage databases.

What I meant is I need a tool to design a database structure (tables, 
fields, relations), so it can generate scripts to physically create the

tables when the model is complete.
I need this tools to make reverse engineering, generate documentation 
about a database, etc....

As far as I know pgAdmin doesn't do that.
steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3 
Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144
steve.toutant at inspq.qc.ca 
http://www.inspq.qc.ca 
 




Martin Fafard <martin.fafard at geoprojection.com>@postgis.refractions.net

Envoyé par : postgis-users-bounces at postgis.refractions.net 
30/06/2009 11:09 AM
Veuillez répondre à
martin.fafard at geoprojection.com; Veuillez répondre à
PostGIS Users Discussion <postgis-users at postgis.refractions.net>


A
PostGIS Users Discussion <postgis-users at postgis.refractions.net>
cc

Objet
Re: [postgis-users] Data modeling tool








Hi Steve

pgAdminIII (pgadmin.org)

Martin F

Steve.Toutant at inspq.qc.ca a écrit : 

Hello, 
I searched for a data modeling/build/management tool for postresql and

postgis. 

I would like to have the opinion of users, which one really works?
Could 
be open source or commercial. 

Regards, 
Steve 

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3 
Tél.: (418) 650-5115 #5281
Fax.: (418) 654-3144
steve.toutant at inspq.qc.ca 
http://www.inspq.qc.ca 
 


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net 
http://postgis.refractions.net/mailman/listinfo/postgis-users 
 



No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.375 / Virus Database: 270.13.0/2210 - Release Date:
06/30/09 
06:10:00

  _______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net 
http://postgis.refractions.net/mailman/listinfo/postgis-users 



_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4883 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090630/53ea12c2/attachment.bin>