Migration Workbench Banner

back |  1  2  3  |  next

Migration Workbench Repository

The Migration Workbench uses a repository, which is a series of tables in the Oracle database, to store all migration information. This allows you to query the initial state of the application before migration. By initially loading the components of the application system into a repository, you can work independently of the production application.

Furthermore, the repository saves useful dependency information about the components being converted. For example, the Migration Workbench will keep 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 areas:

  • The Source Model which is a series of tables in the repository that contain a mirror image of the data dictionary of the source database.


  • The Oracle Model which is a series of Oracle tables that is 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.