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!!
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!!
No comments:
Post a Comment