Purpose

Scenario

Database and Application Migration UGO (referred to as UGO) can help you migrate the schemas of on-premises Oracle databases to Huawei Cloud GaussDB instances. UGO provides database evaluation and object migration for simple, cost-effective database migration.

This document describes how to use UGO to migrate an on-premises Oracle-11g database to a Huawei Cloud Distributed GaussDB 2.7 Enterprise Edition instance. Currently, only the public network can be used to connect source and target databases.

Figure 1 Public network+SSL connection

Resolved Issues

• Enterprise workloads have been growing and evolving fast, and traditional databases lack the scalability needed to keep up. Enterprises need distributed databases.
• Building a traditional database means purchasing and installing servers, systems, databases, and other software. The O&M is expensive and difficult.
• The performance for complex queries on traditional databases is poor.
• Database schema migration is costly and requires professional knowledge.

Service List

• Database and Application Migration UGO (UGO)
• Virtual Private Cloud (VPC)
• GaussDB
• Data Admin Service (DAS)

Notes on Usage

• The details shown in the resource planning table are just examples. The actual resource details will depend on your specific migration.
• The end-to-end test data is for reference only.
• Oracle syntax is complex and flexible, so the workload evaluation and object evaluation statistics are for reference only.