This tutorial teaches you how to manage database changes in a team
environment using the workbench. In this tutorial, you have an existing database.
You want to make changes to the database using the workbench, and prepare
to deploy your changes back to the database server. Before you deploy the
changes, you will use the workbench to compare your changed data model to
the original database and perform an impact analysis to determine how your
changes might impact other objects.
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
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