Updated on 2025-02-22 GMT+08:00

Creating a Database Evaluation Project

Create a database evaluation project and select a target database.

Procedure

  1. Log in to the UGO console.
  2. In the navigation pane on the left, choose Schema Migration > DB Evaluation.
  3. Click Create Project in the upper right corner.
  4. Configure the basic information on the Basic Information page. For details, see Table 1.

    After the basic information is configured, the Test Connection button is available.
    Figure 1 Creating an evaluation project
    Table 1 Parameter description

    Parameter

    Description

    Project Name

    Name displayed in the project list. In this example, the name is Oracle-GaussDB.

    The name must contain 5 to 50 characters, start with a letter, and end with a letter or number. Only letters, numbers, underscores (_), and hyphens (-) are allowed.

    (Optional) Exception Notification Mode

    SMN Topic

    Specifies whether to report exceptions through Simple Message Notification (SMN).

    To create an SMN topic, see Creating a Topic.

    NOTE:

    Follow-up Operations

    After the topic is created, you can add a subscription. After the subscription has been confirmed, alarm notifications will be sent to the subscription endpoint via SMN.

    Source DB Type

    Select Oracle.

    (Optional) Network Type

    Public Network: An elastic IP address (EIP) is used to connect to the source database.

    If the source database network is restricted by an IP address whitelist, add the EIP to the source database network whitelist to ensure that the UGO can connect to the source database.

    EIP in AP-Singapore: 110.238.109.54

    (Optional) Connection Method

    Select Service Name or Connection string. Service Name is used by default. Service Name is used as an example.

    Subsequent parameters vary depending on your selection of this parameter.

    NOTE:

    For connection string, the standard JDBC is used to connect to the source database.

    (Optional) Host Type

    Use Host IP Address as an example.

    Source DB Name

    Enter the name of the database to be evaluated.

    Hostname or Host IP Address

    Enter the host name or host IP address based on the selected host type.

    Host Port

    Enter a database port.

    User Name

    Enter the username of the source database. You are advised to use the administrator username.

    Password

    Enter the password of the source database. The password can contain up to 50 characters.

    (Optional) SSL Type

    Select No SSL. Currently, One Way SSL is unavailable.

    • No SSL: SSL is disabled. There may be potential security risks.
    • One Way SSL: The target database will be authenticated and the transmission will be encrypted.
      • Upload: Upload the root certificate file in JKS format.
      • Trust Store Password: Enter the password of the trust store used to access the certificate.
    NOTE:
    • If you select One Way SSL, enter the correct uploaded file and entered password, which are private information of users.
    • Secure Socket Layer (SSL) is an encryption-based Internet security protocol for encrypting the connection between a server and a client. It ensures the privacy, authentication, and integrity of Internet communications.

    (Optional) Tag

    Use predefined tags in Tag Management Service (TMS). Predefined tags are visible to all service resources that support the tagging function. For details, see Tag Management Service User Guide.

    Enter a key and a value, and click Add.

    A maximum of 20 tags can be added. For details, see Managing Tags.

  5. Click Test next to the Test Connection field.

    • If the connection succeeds, the Next button is available.
    • If the connection test fails, the message "Unable to connect to DB" is displayed.

  6. (Optional) Click Test next to Network Stability. A successful network stability test only means that there is little network latency or packet loss, or no packet loss at the current time. It takes 10s to 15s to complete.
  7. Click Next.

    The check result of each check item is displayed. You can also click Recheck to check the permissions again.
    Figure 2 Precheck

    If there are any failed checks, click Details, modify the item based on the information provided, and click Re-verification.

  8. After all check items are passed, click Next.

    Figure 3 Selecting evaluation scope
    Table 2 Parameter description

    Parameter

    Description

    Object Types to be Collected

    By default, all object types are selected. You can also manually select the object types to be collected if needed.

    Target Database Selection

    Select GaussDB Distributed (compatible with ORA) V2.0-2.7 Enterprise Edition.

    Schemas to be Collected

    Manually select schemas to be collected and click . You can also select all schemas.

    If there are many schemas, you can search for them by name. The names and number of selected schemas are displayed on the right.

    NOTICE:
    • If there are multiple schemas with the same name (case-insensitive), select one of them.
    • The collected Oracle lightweight Jobs will be used as the PROGRAM object type.
    • Only the database objects are collected within the permission scope, that is, within the selected schemas.
    • After you select object types to be collected, UGO will evaluate their compatibility with the target object types and then migrate them.
    • All collected data is stored in the source database of the tenant. The database password encrypted before being saved. Related data is visible only to you on the UGO console.
    • After you delete migration tasks or deregister from UGO, the data is deleted.

  9. Click Next to go to the Confirmation page.

    The basic information, pre-check results, selected target databases, selected and unselected schemas and object types are displayed.
    Figure 4 Confirming the information

  10. Verify the settings and click Create. A message is displayed, indicating that the project is created successfully.
  11. Click OK to go to the DB Evaluation page. You can view the evaluation project you created in the list.

    Data collection, project evaluation, pre-migration evaluation are required. You can view the status in the Evaluation Status column.
    Figure 5 Viewing the created project
    • Before Evaluation Status of an evaluation project becomes Evaluation - Success. Confirm Target DB Pending, you can stop and then continue the creation of the project. When Evaluation Status is Evaluation - Success. Confirm Target DB Pending, you can confirm a target database or re-evaluate objects as needed.
    • The evaluation time varies depending on the number of objects selected.
    • After the evaluation is complete, click a project to view the database evaluation result.
    • During data collection, the system periodically automatically retries the connection to the source database. Next connection retry time: Current time + Time required for checking the connection and network stability + Sleep retry interval. After a connection test, there is several second delay before a network stability check can be performed. You may see a few seconds difference between the two retry times.

  12. When Evaluation Status is Evaluation - Success. Confirm Target DB Pending, and click the project name or click Confirm Target DB Pending.
  13. On the Target DB Analysis tab page, select GaussDB Distributed (compatible with ORA) V2.0-2.7 Enterprise Edition and click Confirm DB Selection.
  14. Click Confirm.
  15. After the target database is confirmed, a dialog box is displayed. You can click:

    • Create Now to go to the Create Migration Project page.
    • Create Later to stay on the current page.

Follow-up Operations

You can view details about the evaluation project.