Compare database schemas visually
Finding differences between databases is a tedious job. DB-VA provides a "visual diff" function for database administrator to compare databases by showing their differences visually. This tutorial shows you how to use visual diff to identify changes of databases from release 1.0 to the latest development version.
Topics
1. Make a copy of current ERD (version 1.0)
2. Modify ERD
3. Compare the changes from version 1.0 to latest changes
| September 1, 2009 | |
User Rating:
/ 1
|
|
| Views: 2,255 | |
|
PDF
Link
Link: |
Add comments |
The database design for the Computer Sales project:
- Let's make a copy of the existing project by selecting File > Save Project as... from the main menu.
- Name as ComputerSales_1_0.vpp and click OK.
- Reopen the previous project by selecting File > Reopen > ..\ComputerSales.vpp.
- Make a few changes to the project. Rename entity Addresses to Customer_Addresses.
- Locate the entity Computer_Part by first pressing CTRL+SHIFT+J to open the Jump To Element dialog box, and input Computer_Part in the text field and press the Enter key to jump to the element.
- Right click on the entity, and select New Column from the main menu.
- Enter discount : numeric(8, 2) as the column definition, press the Enter key and then the Esc key to confirm editing.
- Move the mouse cursor over Computer_Part, press on the One-to-Many Relationship -> Entity icon in the resource-centric interface, and drag to the empty region to create a new entity. Enter Part_Usage as entity name.
- Rename the automatically created FK (foreign key) column to part_id.
- Repeat the previous steps to add the following columns to Part_Usage.
- +usage_id : number(10)
- description : varchar2(1024)
- Open Visual Diff from the toolbar.
- Uncheck Use Working Project at the left hand side.
- Click ..., select the ComputerSales_1_0.vpp and select Physical Database Design as the diagram.
- Check Use Working Project at the right hand side.
- Select Physical Database Design as the diagram of right hand side.
- The differences of diagrams are shown in the bottom list.
- Select the differences to examine one by one.
- Addresses entity
- New column
- New association and entity
- Addresses entity
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
Rate this Article
Click on one of the stars below to rate this article from 1 (lowest) to 5 (highest).
Comments (0)