Migration Workbench Banner

back |  1  2  3  |  next

Migration Workbench Repository

The Migration Workbench uses a repository, which is a set of tables in the Oracle database, to store all migration information. This allows you to view and customize the source and destination database models prior to the actual migration. By initially loading the components of the application system into the repository, you can work independently of the production application.

Furthermore, the repository saves useful dependency information about the components you are converting. For example, the Migration Workbench keeps a record of all the tables accessed by a stored procedure; you can then use this information to understand the impact of modifying a given table.

The Workbench Repository consists of the following:

  • The Source Model tables contain a mirror image of the data dictionary of the source database.


  • The Oracle Model tables are created from the information in the Source Model. It is a visual representation of how the source database will look when generated in an Oracle environment.