After you create application profiles from all the collection packages, you can create an application evaluation project. You must follow the steps shown in the preceding figure to create an application evaluation project.

Preface

  • Applications used to access Oracle databases are complicated. How can I define the transformation workload of an application that is required to migrate an Oracle database?
  • The relationship between applications and databases in an application cluster is complex. How can I formulate a detailed plan to migrate an application cluster?
  • The application has not undergone maintenance for a long period of time, and the maintenance personnel are not sure how to access each table. How can I transform the application after the database has been transformed?

    In this case, the ADAM application evaluation feature can help you analyze the pain points of migration such as the workload of application transformation, SQL compatibility of the application, architectures of the application and database cluster.

Create an application evaluation project

Step 1: Enter the basic information and then select the database to be evaluated and its version.

Step 2: Select one or more application profiles that you want to evaluate, as shown in the following figure.

Step 3: Select the database evaluation project. You must select database profiles that are in the FINISH state. These profiles are associated with the application profile that you selected in Step 2. You can create an evaluation project only when all associated databases are in the FINISH state.

Application evaluation details

Application evaluation details contain the evaluation results, project overview, and joint profiles.

Evaluation results

Evaluation results are displayed based on the overall results, migration groups, and application nodes.

Overall:

Overall results show the combined evaluation results of applications and databases to guide their transformation and migration.

Architecture list: ADAM groups the overall architecture based on the relationship between databases and applications by using intelligent algorithms. A migration group is the smallest subset of a migration unit, meaning that migrating any one migration group will not affect the data dependencies of other migration groups.

Migration score: ADAM scores the difficulty of migration and transformation tasks. A higher score indicates a lower transformation cost for applications. The migration score is subject to the integrity of collected data. We recommend that you consider the migration cost based on your actual business.

Overall compatibility: shows the compatibility of application SQL statements and database objects. SQL statements collected from databases are subject to the database system. Therefore, the compatibility of SQL statements is not used as a reference for evaluation.

Architecture blueprint: shows the status of migration groups in a topology.

Migration groups (migrate_group):

A migration group is the smallest subset of applications that are contained in a database to be migrated. Migration groups do not have any database dependencies on the database nodes of other migration groups.

A migration group includes application nodes and database nodes. You can click an application node to view its evaluation and transformation details.

The evaluation results of a single application includes application dependencies, SQL compatibility, and focus areas of application transformation.

Application dependencies: shows the information of databases on which an application node depends. The minimum dependent objects of applications are schemas.

SQL compatibility: shows the compatibility of application SQL statements, and provides specific transformation rules and focus areas for each SQL statement.

Compatible: shows the number of SQL statements that can be executed in the destination database without transformation.

Compatible after Modification: shows the number of SQL statements transformed by ADAM, which can be executed in the destination database after being replaced in the application.

Incompatible: shows the number of SQL statements that cannot be executed in the destination database. You must modify the application code or SQL statements based on specific transformation suggestions.

Focus areas of application transformation:

shows focus areas of application transformation and provides suggestions based on the overview and details about focus areas of application transformation.