Creating a Database Evaluation Task

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. Read Source Database Preparation and Authorization Tips and click Create.
5. 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.
   Enterprise Project	If you have been associated with an enterprise project, select the target project from the Enterprise Project drop-down list. You can also go to the project management console to create a project. For details about how to create a project, see Enterprise Management User Guide.
   (Optional) Target DB Analysis	Select Skip Target DB Evaluation: UGO will only collect data and not analyze the target database. There are only recommended target databases in the Target DB Analysis tab when you view evaluation project details. Select this option if you already have a confirmed target database. Deselect Skip Target DB Evaluation: UGO will analyze different target databases to produce summary and evaluation reports. Database analysis takes some time after data collection. This option is selected by default.
   (Optional) Source DB Type	Select ORACLE-11g as the source database type.
   (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.
   Data Collected From	Specifies whether to collect data from the DBA views or ALL views. DBA views: UGO collects data from objects in the entire source DB instance. All views (default value): UGO collects data from all objects owned and accessed by the source DB user.
   (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. You can add up to 20 tags. For details, see Managing Tags.

6. 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.

7. (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.
8. Click Next to go to the Precheck page.
   The check result of each check item is displayed. You can also click Recheck to check the permissions again.

   Figure 2 Prechecking permissions of Oracle 11g
   

   

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

9. After all check items are passed, click Next.
   Figure 3 Selecting evaluation scope
   

   Table 2 Parameter description

   Parameter	Description
   Select Object Type for Collection	By default, all object types are selected. You can also manually select the object types to be collected if needed.
   Select Target Database	Select GaussDB Distributed - 2.7 as an example.
   Dynamic SQL Evaluation	Enable: The dynamic SQL statements in objects are analyzed. Disable: The dynamic SQL statements are not analyzed. Currently, UGO only identifies dynamic SQL statements and does not perform any processing.
   (Optional) Select Schema for Collection	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 schema name. The names and number of selected schemas are displayed on the right list. NOTICE: If there are multiple schemas with the same name (case-insensitive), select one of them. Oracle Lightweight Jobs are collected as part of 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 UGO, the data is deleted.

10. 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
    

11. Verify the settings and click Create. A message is displayed, indicating that the project is created successfully.
12. 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, you can click the project name to view its details. For details, see Viewing Project Details.
    • 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.

13. When Evaluation Status is Evaluation - Success. Confirm Target DB Pending, and click the project name or click Confirm Target DB Pending.
14. On the displayed page, select GaussDB Distributed-2.7 as the target database and click Confirm Database Selection.
15. Click Confirm.
16. 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 the detailed information about the evaluation project .