Oracle database reverse engineering
This tutorial is aimed to show the steps of visualizing an Oracle database by forming an ERD (entity relationship diagram) in DB-VA. DB-VA supports the reverse engineering of database tables, stored procedures and triggers. Users can reverse database from small to huge scale, by constructing multiple ERD base on different contexts.
This tutorial will walk through the reversal of database tables. Since the steps for reversing stored procedures and trigger are more or less the same, readers are expected to master all the required techniques in reverse engineering of Oracle database by going through this tutorial.
Topics
1. Open Database to Data Model dialog box
2. Configure JDBC connection
3. Select database schema to be reversed
4. Construct context-based ERDs with the reversed entities
| September 1, 2009 | |
User Rating:
/ 2
|
|
| Views: 1986 | |
|
PDF
Link
Link: |
Add comments |
| Edition: All (Edition comparison) | |
- To reverse database, select Tools > Object-Relational Mapping (ORM) > Reverse Database... from the main menu.
- The Database to Data Model dialog box appear. Un-check Reverse Stored Procedure and Reverse Trigger, since we only want to reverse tables this time. Click Next.
- Select Oracle 9i/10g as Driver.
- Click ... to specify the JDBC driver file.
- Select the Oracle JDBC driver file.
(PS. The JDBC driver file can be found at ${oracle_server_dir}\jdbc\lib, or downloaded from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html) - Fill in the information of the database to reverse, and click Test Connection to verify the connection. Click Next.
- Select specific schema(s) to be reversed by first selecting Selected Schema.
- Select schema John.
- Click Next.
- The tables are listed. Click Check All to reverse all the tables of the schema.
- Click Finish to start the reverse process.
- A blank, new ERD is created in background, and the reversed entities are listed in the Reversed Entities dialog box.
- Select all the entities, and drag them to the ERD.
- ERD is formed with the entities.
Download full functions 30 days FREE trial of DB Visual ARCHITECT
Notes:
1. Select DB Visual ARCHITECT when installing the VP Suite.
2. Click "Try without Evaluation Key" button to get 30 minutes per session evaluation.
3. Click "Request Key" to get a 30-day evaluation key by email (Your email will only be used for sending evaluation key and follow up your evaluation. We will NEVER share your email to third party without your approval).
Oracle is U.S. registered trademark of Oracle Corporation