Print Thread
Auto-Generated ERD Diagrams
#65746 06/19/24 03:01 PM
Joined: May 2007
Posts: 3
Toronto, Canada
J
Member
OP Offline
Member
J
Joined: May 2007
Posts: 3
Toronto, Canada
We have many tables (thousands) with PK/FK relationships

Our clients would like ERD diagrams but trying to make a one to show the whold system would be be ridiculously large, take to long to generate, ...

What we would like a way to "AUTO-GENERATE" diagrams (to what ever layout PL/SQL Developer defaults)
for a list of tables (1 to 10)
from the command line and save the files

This would allow us to constantly update these files as we update our tables
and provide them to our clients as images or better yet .pdd (so they would need to purchase PL/SQL Developer to look at them)?

The generated .pdd files seem to be simple text

Do you have a document specifying the complete format of a .pdd file?

Re: Auto-Generated ERD Diagrams
Jim Oriotis #65748 06/20/24 09:34 AM
Joined: Aug 1999
Posts: 22,554
Member
Offline
Member
Joined: Aug 1999
Posts: 22,554
There is currently no option to auto-generate diagrams. You would need to explicitly create a diagram for each selection of tables.


Marco Kalter
Allround Automations
Re: Auto-Generated ERD Diagrams
Marco Kalter #65752 06/21/24 01:04 PM
Joined: May 2007
Posts: 3
Toronto, Canada
J
Member
OP Offline
Member
J
Joined: May 2007
Posts: 3
Toronto, Canada
I didn't thing there was an auto-generate, but I was hoping I missed something in the documentation.

No worries.

Do you have a document specifying the complete format of a .pdd file?

I could query dba_objects and generate the .pdd file using SPOOL if I knew the .pdd structure/syntax as it seems to be a PLAIN TEXT file.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.014s Queries: 14 (0.006s) Memory: 2.5034 MB (Peak: 3.0399 MB) Data Comp: Off Server Time: 2025-02-17 01:25:41 UTC
Valid HTML 5 and Valid CSS