Обсуждение: RES: RES: Database Diagrams.

Поиск
Список
Период
Сортировка

RES: RES: Database Diagrams.

От
Elielson Fontanezi
Дата:
I have misunderstood me.
What I have tried to say is: Is there any free software like ERWIN to
PostGres?

Elielson,

-----Mensagem original-----
De: Jesus Sandoval [mailto:meli@mzt.megared.net.mx]
Enviada em: quinta-feira, 18 de julho de 2002 10:12
Cc: Pgsql-Admin (E-mail)
Assunto: Re: RES: [ADMIN] Database Diagrams.


Hi....

There is a free tool that does the schema from a DIA (A gnome drawing tool)
which writes the diagram in XML, the address is http://tedia2sql.tigris.org

This is a perl script that just do that, but is very handy, You are asking
for
something that converts from the database to a XML File(and you will have
the
DIA diagram).

Try it, maybe this can help.

Jesus Sandoval



Elielson Fontanezi escribió:

> Hi!
>
>         I would like to know if anyone knows some other software like
dbvis
> which be free.
>         I am working in a project where all projects must be free.
>         I have just looked for some and could not find nothing about it!
>
>         Maybe anyone of you have just seen something anywhere.
>
>         Regards,
>
> Elielson Fontanezi
>
> -----Mensagem original-----
> De: Stephane Schildknecht [mailto:sschildknecht@aurora-linux.com]
> Enviada em: quinta-feira, 18 de julho de 2002 04:56
> Para: geoff@metalogicplc.com
> Cc: Postgresql-Admin
> Assunto: Re: [ADMIN] Database Diagrams.
>
> Le jeu 18/07/2002 à 09:47, Geoff a écrit :
> > Sorry if this is a question that has been answered in some form or
> another,
> > but I need to know if there is a toold of some description that will
help
> me
> > get a diagram of my 7.2.1 database with the relationships. I've done
> various
> > searching on google but found nothing  ( but I may be searching with the
> > wrong phrase's etc ). I'm using a Win32 client to develop, but the DB
runs
> > on a debian linux server.
>
> You can try DbVisualizer :
> http://www.minq.se/products/dbvis/
>
> I think it's a godd product.
>
> There's also dbdoc, I think...
> >
> >
> >
> > -----------------------------------------------------------------------
> > This message is intended only for the person or entity to which it is
> > addressed and may contain confidential and/or privileged material. Any
> > review, retransmission, dissemination or other use of, or taking of any
> > action in reliance upon, this information by persons or entities other
> than
> > the intended recipient is prohibited. If you receive this message in
error
> > please contact the sender by return e-mail and delete the message from
> your
> > computer.
> >
> > Any opinions contained in this message are those of the author and are
not
> > given or endorsed by Metalogic PLC unless otherwise clearly indicated in
> > this message and the authority of the author to bind Metalogic is duly
> > verified.
> >
> > Metalogic PLC accepts no liability for any errors or omissions in the
> > context of this message which arise as a result of internet
transmission.
> > -----------------------------------------------------------------------
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> >
> --
>  _Stéphane SCHILDKNECHT___________________________________
> | AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE     |
> | Tel : 01.58.17.03.20 Fax : 01.58.17.03.21               |
> | mailto:sschildknecht@aurora-linux.com - ICQ : 142504394 |
> | "Free Markets have taught that innovation is best when  |
> |  ideas flow freely." Adam Smith                         |
> |_________________________________________________________|
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: Database Diagrams.

От
Tim Ellis
Дата:
> I have misunderstood me.
> What I have tried to say is: Is there any free software like ERWIN to
> PostGres?

Apparently, dbdesigner is closest to ER/Win. It spews forth SQL DDL
straight from the tool.

Personally, I've been happy laying out tables in Dia. Enough that I wrote
a tool to turn the Dia diagram into SQL DDL (for Postgres). This is less
like ER/Win, because Dia spews forth XML, and you run another commandline
utility that converts XML-->SQL.

Again, links:

dbdesigner: http://dbdesigner.sourceforge.net/
dia2sql: http://freshmeat.net/projects/dia2sql/?topic_id=45
tedia2sql: http://tedia2sql.tigris.org/

--
Tim Ellis
Senior Database Architect
Gamet, Inc.