Re: Reverse engineering PG database
| От | Paul Rosenberg |
|---|---|
| Тема | Re: Reverse engineering PG database |
| Дата | |
| Msg-id | 5.2.0.9.0.20030331120511.00bcd468@pop.netaddress.com обсуждение исходный текст |
| Ответ на | Re: Reverse engineering PG database (Dennis Gearon <gearond@cvc.net>) |
| Список | pgsql-general |
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)
В списке pgsql-general по дате отправления: