Thread: Reverse engineering PG database
We are looking for a DB design program which can reverse engineer a PG database. We want to use this to create revised documentation for the database after changes are made. PG outputs a creation SQL script which uses triggers to define foreign keys and this seems to be unusual and has caused a problem with one software.
Try the company:
http://www.datanamic.com/
Paul Rosenberg wrote:
> We are looking for a DB design program which can reverse engineer a PG
> database. We want to use this to create revised documentation for the
> database after changes are made. PG outputs a creation SQL script
> which uses triggers to define foreign keys and this seems to be
> unusual and has caused a problem with one software.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
Dennis Gearon wrote: > Try the company: > > http://www.datanamic.com/ > I don't see any mention of Postgres there... -- Ken Guest Senior Developer Stockbyte Royalty Free Photos http://www.stockbyte.com ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________
Dennis Gearon wrote: > Try the company: > > http://www.datanamic.com/ > Apologies - I must be blind :) -- Ken Guest Senior Developer Stockbyte Royalty Free Photos http://www.stockbyte.com ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________
1. Dezign from http://www.datanamic.com/ $149
-- My evaluation result: It's not good to use at all.
2. ER diagrammer from http://www.keeptool.com/en/products.html $210
-- Oracle only.
3. Case Studio 2 from http://www.casestudio.com/enu/ $329
-- My evaluation result: The ER diagram picture is not nice. And not good at use. They even don't provide full functional version at trial days.
4. ER/Studio from http://www.embarcadero.com/products/erstudio/index.asp pricing information is not posted on web.
5. QDesigner from quest around 700$
Good to use with Postgresql as well as other RDBMS.
6. AllFusion Erwin Data Modeler from Computer associate
Good to use with Postgresql as well as other RDBMS.
Dennis Gearon <gearond@cvc.net> wrote:
Try the company:
http://www.datanamic.com/
Paul Rosenberg wrote:
> We are looking for a DB design program which can reverse engineer a PG
> database. We want to use this to create revised documentation for the
> database after changes are made. PG outputs a creation SQL script
> which uses triggers to define foreign keys and this seems to be
> unusual and has caused a problem with one software.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
On Tue, 2003-03-25 at 18:29, Paul Rosenberg wrote: > We are looking for a DB design program which can reverse engineer a PG > database. We want to use this to create revised documentation for the > database after changes are made. PG outputs a creation SQL script > which uses triggers to define foreign keys and this seems to be > unusual and has caused a problem with one software. Is this the kind of thing you're looking for: http://www.rbt.ca/autodoc/index.shtml Or did I misunderstand you? Cheers, Neil
I am part of the beta test program, the next version will do those. Paul Rosenberg wrote: > Thanks. > > We are alreaady using Dezign from Datanamic. Unfortunately, it does not > handle the PG use of triggers to implement foreign key referential > integrity. We can generate the PG database from Dezign without problem > not using triggers for foreign keys. > > Our main objective is to be able to implement changes in a production > data base and then be able to update the model so that we have updated > documentation and a model which can generate a script to create the > database. > > If the DB model program can create scripts to alter [non-destructively] > a database based upon changes to the model, then we could use this also. > > At 09:05 AM 3/27/2003 -0800, Dennis Gearon wrote: > >> Try the company: >> >> http://www.datanamic.com/ >> >> Paul Rosenberg wrote: >> >>> We are looking for a DB design program which can reverse engineer a PG >>> database. We want to use this to create revised documentation for the >>> database after changes are made. PG outputs a creation SQL script >>> which uses triggers to define foreign keys and this seems to be >>> unusual and has caused a problem with one software. >>> >>> ---------------------------(end of broadcast)--------------------------- >>> TIP 2: you can get off all lists at once with the unregister command >>> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
Thanks.
We are alreaady using Dezign from Datanamic. Unfortunately, it does not handle the PG use of triggers to implement foreign key referential integrity. We can generate the PG database from Dezign without problem not using triggers for foreign keys.
Our main objective is to be able to implement changes in a production data base and then be able to update the model so that we have updated documentation and a model which can generate a script to create the database.
If the DB model program can create scripts to alter [non-destructively] a database based upon changes to the model, then we could use this also.
At 09:05 AM 3/27/2003 -0800, Dennis Gearon wrote:
We are alreaady using Dezign from Datanamic. Unfortunately, it does not handle the PG use of triggers to implement foreign key referential integrity. We can generate the PG database from Dezign without problem not using triggers for foreign keys.
Our main objective is to be able to implement changes in a production data base and then be able to update the model so that we have updated documentation and a model which can generate a script to create the database.
If the DB model program can create scripts to alter [non-destructively] a database based upon changes to the model, then we could use this also.
At 09:05 AM 3/27/2003 -0800, Dennis Gearon wrote:
Try the company:
http://www.datanamic.com/
Paul Rosenberg wrote:We are looking for a DB design program which can reverse engineer a PG
database. We want to use this to create revised documentation for the
database after changes are made. PG outputs a creation SQL script
which uses triggers to define foreign keys and this seems to be
unusual and has caused a problem with one software.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)