Manage database design changes

In this tutorial, you will reverse engineer a physical data model from a database, modify the physical data model, and prepare to deploy your changes to the server by creating a DDL script. Working in the Data perspective, you will create a data design project, use a wizard to reverse engineer the physical data model, use a diagram to modify the model, and then use the compare editor to compare and merge the modified physical data model with the original database source.

Learning objectives

When you complete the exercises, you will know how to do the following tasks:

Reverse engineer an existing database schema into a physical data model
Visually inspect the model by using a diagram
Use the diagram editor to visually add new relationships to the model
Compare the changed version of the model to the original database
Create a delta DDL script that can be used to deploy your changes back to the database

1 hour and 45 minutes