Re: Data modeling tool

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@... on behalf of Alexander Von Luenen
Sent: Tue 6/30/2009 10:40 AM
To: martin.fafard@...; postgis-users-bounces@...
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@...> 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@...
http://www.inspq.qc.ca 
 




Martin Fafard <martin.fafard@...>@postgis.refractions.net

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


A
PostGIS Users Discussion <postgis-users@...>
cc

Objet
Re: [postgis-users] Data modeling tool








Hi Steve

pgAdminIII (pgadmin.org)

Martin F

Steve.Toutant@... 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@...
http://www.inspq.qc.ca 
 


_______________________________________________
postgis-users mailing list
postgis-users@...
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@...
http://postgis.refractions.net/mailman/listinfo/postgis-users 



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



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