Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
SoftWare Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive

Creating an Evaluation Project

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

Scenarios

Based on basic information (including the number of schemas) about the source database and SQL statements of specific objects, UGO generates a report to evaluate workloads and risks before database migration and recommends a suitable target database, helping you make decisions and work plans during migration.

Suggestions

  • To collect objects, UGO needs to connect to the source database, which may affect the database performance. You are advised to use a database in a non-production environment or perform database evaluation during off-peak hours.
  • GoldenDB as the source database: Create an evaluation task as a CN user.

Constraints

  • If the source database type is MySQL or GoldenDB, the username cannot contain special characters, such as single quotation marks ('), double quotation marks ("), and backslashes (\).
  • UGO cannot evaluate overloaded functions with the same name in the same source database.
  • Each user can create up to 10 evaluation projects.

Procedure

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

    Figure 1 Evaluation project creation

  5. After entering the basic information, click Test.

    • If the connection test succeeds, the Next button will be available.
    • If the connection test fails, an error message is displayed, indicating that the database cannot be connected. For details, see Database Connection Error.

  6. (Optional) Test network stability. A successful network stability test only means that there is a little network latency or packet loss, or no packet loss at the current time. The test lasts for 10 to 15 seconds.
  7. Click Next to go to the Precheck page.

    Figure 2 Prechecking permissions of Oracle database

  8. After all check items are passed, click Next to go to the Evaluation Scope Selection page. Table 2 and Table 3 describe details about the parameters.

    Figure 3 Selecting evaluation scope
    NOTE:
    • Only selected database objects are collected.
    • 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.
    • When a user deletes an evaluation task, the user data is deleted.
    • Dynamic SQL evaluation and object-level permission collection are available only for Oracle databases.

  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.
    • If the source database type is GoldenDB, the database configuration and instance quantity are not displayed.
    • If the source database type is Microsoft SQL Server, database OS, connection string, database time zone, database configuration, and database memory are not displayed.
    Figure 4 Confirming information (Oracle as the source database)
    NOTE:

    The parameters displayed on the task confirmation page vary depending on the source database.

  10. Verify the settings and click Create. A message is displayed, indicating that the project is created.
  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 Project Status column. You can stop a project that is being evaluated or resume a stopped project.
    Figure 5 Viewing the created project
    NOTE:
    • You can create up to 10 evaluation projects.
    • Before Project Status of an evaluation project becomes In progress. Confirm Target DB Pending, you can stop and continue the creation of the project. When the Project Status is In progress. Confirm Target DB Pending, you can confirm a target database by following Confirming the Target Database or re-evaluate objects. However, if the source database type is GoldenDB, re-evaluation is not supported.
    • The evaluation time varies depending on the number of objects selected.
    • After the evaluation is complete, click a project name to view the result by following Viewing 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.

Parameters

Table 1 Basic information

Parameter

Example Value

Description

Project Name

oracle_to_gaussdb_evaluation_project_01

Enter a project name.

The name is unique. It can contain 5 to 50 characters and must start with a letter and end with a digit or letter. Only letters (case-insensitive), digits, underscores (_), and hyphens (-) are allowed.

(Optional) Exception Notification Mode

smn_subject_01

The default value is SMN Topic.

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

To create an SMN topic, see Creating a Topic.

NOTE:

Follow-up Operation

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

Oracle

Select a source database type. For details about supported source database types, see Supported Databases.

If you want to select GoldenDB, Microsoft SQL Server 2012/14/16/17/19/22, or PostgreSQL 10/11/12/13/14/15 as the source database, submit an application by choosing Service Tickets > Create Service Ticket in the upper right corner of the console.

NOTE:

If the source database type is MySQL, run the following command on the source database to enable the CPU count function.

SET GLOBAL innodb_monitor_enable = cpu_n;

(Optional) Network Type

Public network

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

If the source database network is restricted by the 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
  • EIP in LA-Santiago: 159.138.116.198

Connection Method

Service name

Select Service name or Connection string. Service name is used by default. The following uses Service name as an example.

Subsequent parameters vary depending on your selection of this parameter.

  • Oracle:
    Compatible with JDBC formats of IPv4:
    • ip:port:databaseName
    • ip:port/databaseName
    • jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ip)(PORT=port)))(CONNECT_DATA=(SERVICE_NAME=databaseName)))
    • jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=ip)(PORT=port)))(CONNECT_DATA=(SERVICE_NAME=databaseName)))
  • MySQL:
    Compatible with JDBC formats of IPv4:
    • jdbc:mysql://ip:port/databaseName?useUnicode=true&characterEncoding=UTF-8
    • jdbc:mysql://ip:port/databaseName?useUnicode=true&characterEncoding=UTF-8&useSSL=true&requireSSL=true
    • jdbc:mysql://ip:port/databaseName?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true
    • jdbc:mysql://address=(protocol=tcp)(host=ip)(port=port)/databaseName?useUnicode=true&characterEncoding=UTF-8
    • jdbc:mysql://address=(protocol=tcp)(host=ip)(port=port)/databaseName?useUnicode=true&characterEncoding=UTF-8&useSSL=true&requireSSL=true
    • jdbc:mysql://address=(protocol=tcp)(host=ip)(port=port)/databaseName?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true
  • PostgreSQL:

    Compatible with JDBC formats of IPv4:

    • jdbc:postgresql://ip:port/databaseName
  • GoldenDB:
    Compatible with JDBC formats of IPv4:
    • jdbc:mysql://ip:port/databaseName?useUnicode=true&characterEncoding=UTF-8
    • jdbc:mysql://ip:port/databaseName?useUnicode=true&characterEncoding=UTF-8&useSSL=true&requireSSL=true
    • jdbc:mysql://ip:port/databaseName?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true
    • jdbc:mysql://address=(protocol=tcp)(host=ip)(port=port)/databaseName?useUnicode=true&characterEncoding=UTF-8
    • jdbc:mysql://address=(protocol=tcp)(host=ip)(port=port)/databaseName?useUnicode=true&characterEncoding=UTF-8&useSSL=true&requireSSL=true
    • jdbc:mysql://address=(protocol=tcp)(host=ip)(port=port)/databaseName?useUnicode=true&characterEncoding=UTF-8&allowPublicKeyRetrieval=true
NOTE:
  • For connection string, standard JDBC is used to connect to the source database.
  • If the source database type is Microsoft SQL Server, only Service name can be selected.

Host Type

Host IP Address

Select Hostname or Host IP address.

Hostname/Host IP Address

192.168.1.2

Host IP Address: IPv6 addresses are not supported.

Hostname:

  • The host name cannot be empty.
  • You can enter multiple host names and use commas (,) to separate them. All host names can contain up to 1,024 characters.
  • A host name can contain a maximum of 253 characters and cannot contain the following special characters: '!', '@', '#', '$', ' %', '^', '&', '*', '(', ')', '+', '=', '[', ']', '{', '}', '|', '\', ':', ';', '<', '>', ',', '?', '/'

Source DB Name

source_db_01

Name of a source database to be evaluated.

The source database name:

  • Consists of letters, digits, periods (.), underscores (_), hyphens (-), dollar signs ($), and number signs (#).
  • Contains 2 to 128 characters.
  • Starts with a letter, digit, dot (.), underscore (_), or hyphen (-) and can be enclosed in quotation marks (").
NOTE:

This parameter is not displayed when the source database type is MySQL.

Host Port

1521

Enter a database port. The port number ranges from 1 to 65535.

Username

source_user_01

Enter the username of the source database. It can contain up to 128 characters. You are advised to use the administrator username.

The username can contain 2 to 128 characters and must start with a letter, digit, period (.), underscore (_), or hyphen (-). Only letters, digits, periods (.), underscores (_), hyphens (-), dollar signs ($), and number signs (#) are allowed. The username can be enclosed in double quotation marks ("").

Password

Pass@worD#?

Enter the password of the source database. The value contains up to 50 characters.

SSL Type

No SSL

Select No SSL. Currently, One-way SSL is unavailable.

  • No SSL: The SSL security protocol is disabled. There may be potential security risks.
  • One-way SSL: The target database will be authenticated and 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:
  • Secure Socket Layer (SSL) provides a secure connection between the network and application layers. In mutual SSL authentication, an SSL connection between a client and a server is established only if they validate each other's identity using digital signatures. If SSL is disabled, your data may be at risk.
  • If the source database type is Oracle 10g or 11g, one way SSL is not supported.
  • If the source database type is PostgreSQL, only PEM SSL certificates can be uploaded, and the trust password is not required.

(Optional) Tags

tag_key_01 = tag_value_01

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.

Table 2 Parameters for selecting the evaluation scope

Parameter

Example Value

Description

Object Types to be Collected

Select All

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

NOTE:

If the source database type is MySQL and its version is earlier than 8.0, there are no ROLE objects in the source database. UGO does not collect ROLE objects.

If the source database type is GoldenDB, there are no ROLE objects in the source database. UGO does not collect ROLE objects.

Target Database Selection

GaussDB Centralized (compatible with A) V2.0-8.200 Enterprise Edition

Select target databases and click . You can also select all of them.

The target databases that you did not select will not be evaluated.

Schemas to be Collected

schema_01

Manually select the schemas to be collected and click . You can search for or 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 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.
Table 3 Advanced settings

Parameter

Example Value

Description

Target DB Analysis

Skip Target DB Evaluation

Whether the target database needs to be evaluated. Skip Target DB Evaluation is selected by default.

  • If Skip Target DB Evaluation is selected, UGO only collects data. The target databases will not be evaluated, so no evaluation report is generated. There are only recommended target databases on the Target DB Analysis tab page when you view the evaluation result by following Viewing the Database Evaluation Result. Select Skip Target DB Evaluation if you have determined a target database.

    If you need to re-evaluate the task after the evaluation project is created, go to the evaluation project list page, locate the project, click More and choose Re-Evaluate in the Operation column. You can view the evaluation result of the target database only after the re-evaluation.

  • If you deselect Skip Target DB Evaluation, an evaluation report of the target database will be generated.

Dynamic SQL Evaluation

Enable

Whether dynamic SQL statements need to be evaluated. Enable is selected by default.

  • If Enable is selected, dynamic SQL statements in objects are analyzed, and a report is generated.
  • If Enable is deselected, dynamic SQL statements are not analyzed.

We use cookies to improve our site and your experience. By continuing to browse our site you accept our cookie policy. Find out more

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback