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