Updated on 2024-03-08 GMT+08:00

Viewing Evaluation Project Details

For details about how to create an evaluation project, see Creating an Evaluation Project.

Scenarios

This section describes how to view the detailed information of an evaluated project, including the source database analysis, database schema, and target database analysis. This helps you select the target database.

Prerequisites

Evaluated projects have been created.

Constraints

If Skip Target DB Evaluation is selected (default setting) when you create an evaluation project, there are only the basic information of recommended target databases on the Target DB Analysis tab.

Procedure

  1. Log in to the UGO console.
  2. In the navigation pane on the left, choose Schema Migration > DB Evaluation.

    All the evaluation projects are displayed in the list. You can view the project basic information, including the project name/ID, connection type, and project status. The project ID can be directly copied.

    If there are many projects, you can search for them by project status, tag, and project name/ID.

    Figure 1 Database evaluation

  3. Click the name of the project that you want to view. The Source DB Analysis, Target DB Analysis, and Tags tabs are displayed.

    Figure 2 Evaluation information classification
    Table 1 Function description of the Source DB Analysis tab

    Function

    Description

    Basic Information

    Displays basic information, including the project name, source database type, database version, database name, number of instances, and database memory.

    NOTE:

    If the source database type is GoldenDB, the database configuration and instance quantity are not displayed.

    If the source database type is MySQL and GoldenDB, database names are not displayed.

    Object Statistics

    Displays the number of database objects. The objects displayed vary depending on the source database type.

    Click View Object Details to view details about the database schemas. For details, see Table 2.

    NOTE:

    The numbers of object types such as Cluster are not displayed.

    Object Distribution

    Displays the database object statistics in a bar chart. Hovering over on a bar shows the exact values.

    Source DB analysis provides a reference for you to select a target database.

    Table 2 Function description of the DB Schema tab

    Function

    Description

    Schema list

    Displays the schema, object name, object type, and operation.

    • If there is a large amount of data, you can search for your desire data by DDL collection status, schema, wrapped object status (only available for Oracle database), or object name.
    • Incremental evaluation: The SQL data has to be incrementally evaluated if:
      • The DDL collection status is Not collected.
      • The wrapped objects are edited.
    • Click View Details in the Operation column to view the detailed information and SQL script of the object.
    • Locate an object and click Edit SQL in the Operation column to edit the SQL script of the object.
    NOTE:
    • Edit SQL is available only when the target database is not confirmed and any of the following conditions is met:

      The wrapped objects are edited.

      The DDL Collection Status of objects is Collected.

    • If Object Type is SQL for a schema, View Details is unavailable.

    DB Objects (for Oracle database)

    Include storage objects, code objects, job objects, and management. You can click an object to view the corresponding information.

    • Storage: include SEQUENCE, TABLE, INDEX, SYNONYM, and TYPE.
    • Code: include VIEW, MATERIALIZED_VIEW, TRIGGER, TYPE_BODY, PROCEDURE, FUNCTION, PACKAGE, DB_LINK, PACKAGE_BODY, and DIRECTORY.
    • Job Objects: include CREDENTIAL, PROGRAM, SCHEDULE, JOB_CLASS, and JOB.
    • Management: include USER, ROLE, and GRANT.

    DB Objects (for MySQL database)

    Include storage objects, code objects, and management objects. You can click an object to view the corresponding information.

    • Storage: include TABLE, VIEW, and SCHEMA.
    • Code: include FUNCTION, PROCEDURE, and TRIGGER.
    • Management: includes GRANT, ROLE, and USER.

    DB Objects (for PostgreSQL database)

    Include storage objects and code objects. You can click an object to view details.

    • Storage: include SCHEMA, TABLE, and INDEX.
    • Code: include VIEW, TRIGGER, PROCEDURE, and FUNCTION.

    DB Objects (for GoldenDB database)

    Include storage objects, code objects, and management objects. You can click an object to view the corresponding information.

    • Storage: include TABLE, VIEW, and SCHEMA.
    • Code: include FUNCTION, PROCEDURE, and TRIGGER.

    Management: includes GRANT, ROLE, and USER.

    DB Objects (for Microsoft SQL Server database)

    Include storage objects and code objects. You can click an object to view details.

    • Storage: include SCHEMA, TABLE, VIEW, and INDEX.
    • Code: include TRIGGER, FUNCTION, and PROCEDURE.
    Table 3 Function description of the Target DB Analysis tab

    Function

    Sub-function

    Description

    Target DB Selection

    NOTE:

    The price is an estimate and may differ from the final price.

    Summary Report

    Click Summary Report to download the compatibility evaluation summary report in PDF format to the local PC. You can view basic information about the source database and analysis results of the target database in the report.

    If the source database type is Microsoft SQL Server, this function is unavailable.

    Database List

    The information includes names, versions, and success rates of the target databases that you can select.

    NOTE:
    • By default, the database with the highest success rate is selected. You can also select a database.
    • The database compatibility evaluation changes as you change the target database. Comprehensive evaluation facilitates you to make a choice.

    Confirm DB Selection

    You can determine the target database type to complete the evaluation.

    If the target database has been confirmed, the button is unavailable.

    Re-Evaluate

    This function is displayed only when Project Status is In progress. Confirm Target DB Pending.

    You can re-evaluate objects as needed.

    The time required depends on the number of objects.

    NOTE:
    • After the re-evaluation, the target database selection, workload evaluation, object conversion statistics, and partially compatible/unsupported syntax are displayed on the current page.
    • This function is not available for Microsoft SQL Server databases.

    Compatibility Analysis

    Current Dynamic SQL Evaluation Config

    Only when the source database is Oracle, information such as object type, schema name, object name, and dynamic SQL information are displayed.

    Click Dynamic SQL Evaluation Report to download the evaluation report, which contains the object type, object name, keyword, location, and statements.

    Workload Evaluation

    The estimated workloads required for reconstructing common objects, system objects and other objects during database migration are displayed.

    Evaluation Statistics

    Only when the source database is Oracle, supported objects and unsupported objects are displayed. Supported objects include native-supported objects, UGO-supported objects, and supported objects with risks.

    Move the cursor to a bar chart to view the conversion details. You can click a bar chart to view the conversion analysis details, which are displayed by supported objects with risks and unsupported objects.

    Click View details to view supported objects with risks and unsupported objects.

    Click Report on Partially Compatible and Unsupported Objects. This report includes all source SQL statements and details on any syntax conversion failures.

    Click Anonymous Report on Partially Compatible and Unsupported Objects. This report includes all source SQL statements and details about any failure points in the SQL statements, but the statements will be anonymized. The actual syntax will not be exposed.

    Partially Compatible/Unsupported Syntax

    All partially compatible or unsupported syntax points during database object conversion are displayed. The detailed information includes Partially Compatible/Unsupported Syntax, Object Scope, Type (not supported or partially compatible syntax points), Risk Level (risk level of partially compatible syntax points), Count (number of occurrences of a syntax point), and Operation (for viewing definition of syntax points).

    Locate a syntax point and click View Definition in the Operation column to view its explanation. If a syntax point is partially compatible, UGO provides different conversion configuration items for the syntax point. During the migration, you can select a configuration item as needed.

    If no modification suggestion is provided, you can click the syntax point name to view details.

    If the source database type is Microsoft SQL Server, this function is unavailable.

    Oracle Object Types and Object Attributes

    If the source database is Oracle and the target database is GaussDB, locate the project to be analyzed in the evaluation project task list and choose More > Collect Object Attribute in the Operation column. When the project status shows that the object attribute collection is complete, you can view the collected data on the Target DB Analysis tab.

    • Click Download Attribute Data Report to download the .tar.gz file to the local PC. The report analyzes the evaluation results of compatibility between the source and target databases by object type and attribute.
      • The Supported Object Types report shows compatibility evaluation results of object types and the number of objects of each object type in the source database.
      • The Supported Attributes report shows the attribute name and attribute value of each object and how often each attribute value appears in the source database. The compatibility results of each attribute are displayed, including the compatibility conclusion, compatibility description, and incompatibility impact analysis.
    • The information includes the object types of the source Oracle database, number of each object type, and compatibility of each object type.
    • Click next to an object type to view the attribute name, quantity, and compatibility of the object type.

      Click View Object List to view details about the objects.

    NOTE:

    For a database evaluation project, object attributes can be collected only once.

    System Objects

    The page displays the types of system objects, occurrence count, and compatibility if the target database is GaussDB and its version is later than 2.0. You can click a system object name to view its database objects.

    Click System Objects Report, a compressed package is downloaded to the local PC. You can extract an excel file from the package. There are two sheet System Data Report and System Table And View Details in the file.

    • System Data Report describes the compatibility of all system objects. The following information includes: target database type and version, system object type, name and quantity, supported type, and SQL statements. If a SQL character string is greater than the maximum value of a cell in the excel file, an independent SQL file is generated and stored in the compressed package.
    • System Table And View Details describes the column compatibility of all system views. The following information includes system object name, column name, quantity, and supported type.

The source database syntax is complex and flexible, so the workload evaluation and object evaluation statistics are for reference only.