Thread: Reverse engineering SW

Reverse engineering SW

From
Bruno Cochofel
Date:
Hi you all,

His there any SW that can do reverse engineering on postgreSQL
databases? I need something that can create entity-relationship models
from an already made db, and something that can create a db from a model.

Thanks,
Bruno

Re: Reverse engineering SW

From
"Dann Corbit"
Date:
I use ER/Win for that.  There are some other tools too.  Search the
archives.

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Bruno Cochofel
> Sent: Tuesday, October 18, 2005 8:16 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Reverse engineering SW
>
> Hi you all,
>
> His there any SW that can do reverse engineering on postgreSQL
> databases? I need something that can create entity-relationship models
> from an already made db, and something that can create a db from a
model.
>
> Thanks,
> Bruno
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

Re: Reverse engineering SW

From
Chris Travers
Date:
pg_autodoc is nice and open source....

Generates HTML, DIA, and other formats....

Best Wishes,
Chris Travers
Metatron Technology Consulting
Dann Corbit wrote:

>I use ER/Win for that.  There are some other tools too.  Search the
>archives.
>
>
>
>>-----Original Message-----
>>From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
>>owner@postgresql.org] On Behalf Of Bruno Cochofel
>>Sent: Tuesday, October 18, 2005 8:16 PM
>>To: pgsql-general@postgresql.org
>>Subject: [GENERAL] Reverse engineering SW
>>
>>Hi you all,
>>
>>His there any SW that can do reverse engineering on postgreSQL
>>databases? I need something that can create entity-relationship models
>>from an already made db, and something that can create a db from a
>>
>>
>model.
>
>
>>Thanks,
>>Bruno
>>
>>---------------------------(end of
>>
>>
>broadcast)---------------------------
>
>
>>TIP 5: don't forget to increase your free space map settings
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>
>
>
>


Attachment

Re: Reverse engineering SW

From
jeff sacksteder
Date:
google for postgresql_autodoc-1.21

On 10/18/05, Dann Corbit <DCorbit@connx.com> wrote:
I use ER/Win for that.  There are some other tools too.  Search the
archives.

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org ] On Behalf Of Bruno Cochofel
> Sent: Tuesday, October 18, 2005 8:16 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Reverse engineering SW
>
> Hi you all,
>
> His there any SW that can do reverse engineering on postgreSQL
> databases? I need something that can create entity-relationship models
> from an already made db, and something that can create a db from a
model.
>
> Thanks,
> Bruno
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

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

              http://www.postgresql.org/docs/faq

Re: Reverse engineering SW

From
"codeWarrior"
Date:
You can also reverse engineer a postgreSQL RDBMS using an ODBC driver and
MicroSloth's Visio.....



"Bruno Cochofel" <bruno.cochofel@gmail.com> wrote in message
news:4355BA72.6000808@gmail.com...
> Hi you all,
>
> His there any SW that can do reverse engineering on postgreSQL
> databases? I need something that can create entity-relationship models
> from an already made db, and something that can create a db from a model.
>
> Thanks,
> Bruno
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>



Re: Reverse engineering SW

From
Ledina Hido
Date:
On 19 Oct 2005, at 16:05, codeWarrior wrote:

> You can also reverse engineer a postgreSQL RDBMS using an ODBC
> driver and
> MicroSloth's Visio.....
>
>
>
> "Bruno Cochofel" <bruno.cochofel@gmail.com> wrote in message
> news:4355BA72.6000808@gmail.com...
>
>> Hi you all,
>>
>> His there any SW that can do reverse engineering on postgreSQL
>> databases? I need something that can create entity-relationship
>> models
>> from an already made db, and something that can create a db from a
>> model.
>>
>> Thanks,
>> Bruno
>>

What about tools to get from UML class diagrams to PostgreSQL? Are
there any of those around?

Thanks,
Ledina

Re: Reverse engineering SW

From
Tino Wildenhain
Date:
Am Mittwoch, den 19.10.2005, 21:05 +0100 schrieb Ledina Hido:
> On 19 Oct 2005, at 16:05, codeWarrior wrote:
>
> > You can also reverse engineer a postgreSQL RDBMS using an ODBC
> > driver and
> > MicroSloth's Visio.....

Were you sucessfully w/ it? If so, which exact versions of all?
(PG, Visio, ODBC)

btw. DB Visualizer has a very nice reverse engineering.


Re: Reverse engineering SW

From
Hannes Dorbath
Date:
On 19.10.2005 05:16, Bruno Cochofel wrote:
> His there any SW that can do reverse engineering on postgreSQL
> databases? I need something that can create entity-relationship models
> from an already made db, and something that can create a db from a model.

Casestudio does this very nice.


--
Regards,
Hannes Dorbath

Re: Reverse engineering SW

From
Tino Wildenhain
Date:
Hannes Dorbath schrieb:
> On 19.10.2005 05:16, Bruno Cochofel wrote:
>
>> His there any SW that can do reverse engineering on postgreSQL
>> databases? I need something that can create entity-relationship models
>> from an already made db, and something that can create a db from a model.
>
>
> Casestudio does this very nice.

Yes, the latter it does very nice. But the former not so - it lacks
an autorouter and you have a hard time to move table objects around
until you can see something ;)