< Previous | Next >

Managing database design changes

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

Lessons in this tutorial

< Previous | Next >