| Author |
Message |
|
2007/06/22 01:22
|
|
|
damien_dougan
Joined: 2007/05/11
Messages: 5
Offline
|
|
|
|
Hi,
Is it possible to use the ERM Diagram to visually define DB sequences and/or triggers?
We have sequences which are not attached to primary keys (indeed, some are not used within tables, but are simply present as a single point of contact for distributed nodes requiring the next value from a consolidated sequence).
Also, is it possible to define triggers visually? (Even if its just adding SQL to INSERT, UPDATE or DELETE within the VP project).
Ideally, we'd like the VP project to be the master data source of the DB, so the documentation is always up to date with the DB!
Furthermore, to support automated DB creation, we'd like our nightly build and integration system to be able to use an API to create the DDL for the database so it can be created within the build environment. Does such a mechanism exist?
Thanks,
Damien
|
|
|
|
 |
| |
|
|
2007/06/22 09:51
|
|
|
Jick
Joined: 2005/04/29
Messages: 2880
Offline
|
|
|
|
Hi damien_dougan,
Do you mean you want to generate sequence/triggers to DDL? Or, you only want to model it in diagram?
Best regards,
Jick
|
Visual Paradigm International Ltd.
http://www.visual-paradigm.com
Build Quality Applications Faster, Better and Cheaper |
|
|
|
|
| |
|
|
2007/06/22 19:38
|
|
|
damien_dougan
Joined: 2007/05/11
Messages: 5
Offline
|
|
|
|
Hi Jick,
The answer to your question is both 
Visually, we'd like to see the sequence and triggers. But we'd also like to have the DDL/DML relating to them available from within the project.
As an example, if we had an element in the model that represented a sequence, then opening the specification would allow the DDL for creating the sequence to be defined.
Thanks,
Damien
|
|
|
|
|
| |
|
|
2007/06/26 09:25
|
|
|
Jick
Joined: 2005/04/29
Messages: 2880
Offline
|
|
|
|
hi Damien,
Thanks for your reply. Will discuss this with our engineers.
Best regards,
Jick
|
Visual Paradigm International Ltd.
http://www.visual-paradigm.com
Build Quality Applications Faster, Better and Cheaper |
|
|
|
|
| |
|
|
2007/06/26 11:26
|
|
|
Jick
Joined: 2005/04/29
Messages: 2880
Offline
|
|
|
|
Hi Damien,
We will support this in the future. We hope to have this ready in September. Will keep you posted on this issue.
Best regards,
Jick
|
Visual Paradigm International Ltd.
http://www.visual-paradigm.com
Build Quality Applications Faster, Better and Cheaper |
|
|
|
|
| |
