All Products
Search

This Product

    Data Transmission Service:Evaluate a database

    Document Center

    Data Transmission Service:Evaluate a database

    Last Updated:Jul 27, 2023

    Advanced Database & Application Migration (ADAM) allows you to evaluate the compatibility and specifications of destination databases, and migration risks. This helps you further understand the feasibility and transformation costs of database migration.

    Create an evaluation project

    Note

    On the Select Destination DB tab, click Next: Select Destination Database to create an evaluation project. Alternatively, you can perform the following steps:

    1. Log on to the Data Management (DMS) console V5.0.

    2. In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Database Evaluation.

    3. Click the Evaluate Dest. DB tab.

    4. Click Create Project.

    5. In the Create Project panel, set the parameters.

      Parameter or setting

      Description

      Project Name

      Enter the name of the evaluation project. You can use the name in subsequent database transformation and migration.

      Source Database Profile

      Select the source database profile.

      Project Type

      Select the type of destination database.

      Destination Database Version

      Select the version of the destination database.

      Are you sure that you want to evaluate invalid objects?

      Specify whether to evaluate invalid objects in the source database profile. Valid values:

      • Yes: evaluates invalid objects in the source database profile.

      • No: does not evaluate invalid objects in the source database profile.

      Note

      During the O&M or data migration of the source database, some objects such as packages, procedures, functions, and views may become invalid.

      Kernel Version

      This parameter is required if the destination database is a PolarDB for Oracle database.

      Report Language

      Select the language of the evaluation report. Valid values:

      • Chinese

      • English

      Select schema

      Add the schemas that you want to evaluate.

      1. In the Not Selected section on the left, select the schemas that you want to evaluate.

      2. Click the image..png icon to add the selected schemas to the Selected section on the right.

    6. Click Create.

      After the evaluation project is created, ADAM analyzes the types of destination databases suitable for this scenario and generates an evaluation report.

    View the evaluation result

    1. Log on to the DMS console V5.0.

    2. In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Database Evaluation.

    3. Click the Evaluate Dest. DB tab.

    4. Find the evaluation project that you want to view and click Details in the Actions column.

      Note

      If the evaluation project is in the Complete state, the evaluation on destination databases is complete.

    5. On the evaluation details page, view the evaluation result.

      • Project Summary:

        The overview of the evaluation project, including the project name, source database profile, source database type, project type, and version of the destination database.

      • Evaluation Overview:

        • Compatibility: the object compatibility and SQL compatibility. The evaluation project evaluates the compatibility between the source and destination databases. The higher the compatibility, the fewer the SQL statements and objects that need to be transformed.

        • Transformation: the number of areas of the destination database transformation.

          • Object Transformation: the database objects that are transformed by ADAM and do not need to be modified.

          • Application Transformation: the focus areas of application transformation that are obtained by analyzing SQL statements collected from the database during preliminary evaluation.

        • Specifications: the required specifications of the destination database and migration cost calculated by ADAM based on collected data. The evaluation of the specifications is subject to the data collection environment. Purchase databases based on your business requirements.

        • Risks: the existing risks of the source database and risks that may arise when the database is migrated. This dimension provides you with warnings about database migration and transformation, including existing risks of the source database and risks that may be generated when the database is migrated.

        • Overall Compatibility: the object compatibility and SQL compatibility after data migration from the source database to the destination database.

      • Evaluation Details: In the Evaluation Details section, click Details in the Actions column to view the details of each evaluation item. For more information, see the Evaluation Details section in this topic.

    6. Optional. Download the evaluation report.

      • You can click Download Simple Report, Download All Report, or Download HTML Report to download the report that you want.

      • You can also click Custom report to customize sections in the report.

    Evaluation Details

    Object Compatibility

    The Schema Compatibility panel shows the evaluation results of all database objects, including compatible and incompatible database objects.

    ADAM provides the transformed DDL statements and focus areas of transformation for objects that can be compatible after transformation. ADAM also explains why objects are incompatible and provides suggestions to transform them.

    SQL Compatibility

    The SQL Compatibility panel shows the evaluation results of SQL statements collected from the source database.

    Click the Evaluation Summary tab to view the overview of the evaluation results. The overall evaluation results of SQL statements that are compatible, incompatible, and compatible after transformation are shown.

    Click the Evaluation Details tab to view the compatibility details of SQL statements. The detailed evaluation results of SQL statements are shown from the following dimensions: compatibility, source SQL statements, and destination SQL statements.

    • Click View in the Source SQL Statements column to view the details of the source SQL statements.

    • Click View in the Destination SQL Statements column to view the details of the destination SQL statements. On the Error Message or Edit Information tab of the Destination SQL Statements panel, view the cause of incompatibility or information to be modified.

    Note

    ADAM evaluates the compatibility of SQL statements based on SQL statements executed and recorded in the destination database. You need to decide whether a specific SQL statement was issued by your business by using the ADAM application evaluation feature.

    Click the Rule Details tab to view the detailed compatibility rules.

    Project Transformation

    The Project Transformation panel lists the focus areas of database transformation. You can transform your database objects based on these focus areas. You can also apply to use the ADAM database transformation feature to transform database objects. Some objects may need to be manually modified.

    Transformation Level: All database objects that need to be transformed are classified by transformation difficulty to help you schedule transformation tasks. The higher the transformation level is, the more difficult the transformation.

    Click View in the Source DDL Operation column to view the source DDL operation.

    Click View in the Destination DDL Operation column to view the destination DDL operation.

    Click Database in the Transformation column to view the ID and transformation method of the focus area.

    Destination Database Solution

    The Destination Database Solution panel provides specifications and migration plan guidelines to help you migrate databases to Alibaba Cloud.

    The specifications of the recommended destination database are generated based on the configurations, performance, SQL, and external dependencies of the source database, and the comprehensive analysis of the source and destination databases.

    On the Destination Database Solution tab, click Details in the Actions column to view the details of the objects in each migration group.

    On the Cross-database Objects tab, click Details to view details of cross-database objects. A solution that has multiple instances may contain cross-database objects.

    Migration Risk

    Migration risks include risks from source and destination databases.

    Risks from the source database may arise when you execute SQL statements that cause high CPU utilization and memory usage in the source database, such as SQL statements of the TOP CPU and TOP Buffer types.

    Risks from the destination database may arise when you transform database schemas or execute SQL statements in the destination database. You must focus on migration risks to prevent performance differences caused by heterogeneous database migration.

    Project Dependency (Schema)

    The Project Dependency (Schema) panel shows dependent objects, referenced objects, and provides suggestions on these objects.

    What to do next

    In the lower part of the Evaluate Dest. DB tab, click Start DB Transformation to go to the procedure of database transformation and migration. For more information, see Database transformation and migration.