Visual Paradigm logo
Jump to Menu

Comparing Database Schemas Visually

Finding differences between databases is a tedious job. Visual Paradigm 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.

Compatible edition(s): Enterprise, Professional, Standard

  • September 1, 2009
  • Views: 22,736
  • PDF

Overview

  1. Make a copy of current ERD (version 1.0)
  2. Modify ERD
  3. Compare the changes from version 1.0 to latest changes

Here is the database design for the Computer Sales project. We are going to modify it, and then compare it with the original copy.

Computer sales project ERD

Using Visual Diff

  1. Download ComputerSales.vpp. You can also find this file at the bottom of this tutorial.
  2. Open the downloaded .vpp file in Visual Paradigm. To open a project, select Project > Open from the application toolbar.
  3. Let's make a copy of the existing project by selecting Project > Save > Save as from the application toolbar.
  4. Name as ComputerSales_1_0.vpp and click OK.
    Save as new project
  5. Reopen the previous project by selecting Project > Open > ..\ComputerSales.vpp.
  6. Make a few changes to the project. Rename entity Addresses to Customer_Addresses.
    Rename entity
  7. Add a new column to entity Computer_Part by right clicking on it and selecting New Column from the main menu.
    New column
  8. Enter discount : number(8, 2) as the column definition, press the Enter key and then the Esc key to confirm editing.
    Naming column
  9. Create an entity with a One-to-Many Relationship -> Entity relationship from Computer_Part. Name the entity Part_Usage.
  10. Add the following columns to Part_Usage.
    • +id : number(10)
    • description : varchar2(1024)

    Entity create
  11. Open Visual Diff by selecting Modeling > Visual Diff from the application toolbar.
    Open Visual Diff
  12. In the Visual Diff window, uncheck Use Working Project on the left hand side.
    Unlock Use Working Project
  13. Click ..., select the ComputerSales_1_0.vpp and select Computer Sales as the diagram.
    Select diagram
  14. Check Use Working Project at the right hand side. Select Computer Sales as the diagram of right hand side.
    Select diagram
  15. The differences of diagrams are listed at the bottom part of the window.
  16. Select the differences one by one to see the changes.
    • Addresses entity
      Using Visual Diff
    • New column
      Using Visual Diff
    • New associated entity
      Using Visual Diff



Trademark Disclaimer

Oracle is U.S. registered trademark of Oracle Corporation


Turn every software project into a successful one.