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:
Paul Rosenberg wrote:
Show quoted text
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:
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:
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 associateGood to use with Postgresql as well as other RDBMS. Dennis Gearon <gearond@cvc.net> wrote:Try the company:
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
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:
Show quoted text
Try the company:
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)
I am part of the beta test program, the next version will do those.
Paul Rosenberg wrote:
Show quoted text
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:
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)