Wednesday, April 30, 2014

How to reverse engineer existing schema with Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler is a very nice tool.
It's very useful on creating Data Model design; besides, it could also help us to reverse engineer the existing schema into Data Model design.
Below are the steps to reverse engineer an existing schema into Data Model.

Steps
1. Goto Data Dictionary Import Wizard
    File > Import > Data Dictionary

2. Choose a Data Dictionary to import
    Choose a configured Data Dictionary from the right table with Connection Name and Connection Details.
    If the expected Data Dictionary is not there, then follow this link to create it.

3. Click Next after chosen a Data Dictionary

4. Chose a schema > Next

5. Select the objects you wish to import
    You may select all or partially depends on your selection.

6. Click Next > Finish

7. Waiting to generate your design

8. Close/Save the log, and review the reverse engineered design.


Done!!

LinkWithin

Related Posts Plugin for WordPress, Blogger...