This tutorial teaches you how to manage database changes
in a team environment with the workbench.
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. 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 lessons, 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 add new columns to tables
- 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
Time required
This tutorial should take
approximately 1 hour and 45 minutes to finish. If you explore other
concepts related to this tutorial, it could take longer to complete.
Skill level
Advanced
Audience
Data architects