Best method to create an ER diagram from existing system

SuperBoot · #1 (**permalink**) 07-02-03, 22:15

Hi all,

I have just started a new job and they have an existing system with an Oracle8i backend and a PowerBuilder front end. Unfortunately they have little documentation and no ER diagrams. What is the best way to create these from Oracle? I have used SQL*Server 2000 and that allows you to drag tables onto a diagram sheet and view all the relationships. Is there something similar for Oracle? I currently have access to SQL*Plus and TOAD.

Your advice is apprectiated.

Regards

osy45 · #2 (**permalink**) 07-03-03, 02:12

try powerdesigner to reverse engineer your data model or any other reveng tool.

you can pick a trial version from www.sybase.com

SuperBoot · #3 (**permalink**) 07-03-03, 03:03

Thanks osy45

I will give it a go.

I found a helpful entry in the archive, see -- http://dbforums.com/arch/50/2002/9/504198

Cheers