What is UGO?

Database and Application Migration UGO, referred to as UGO, is a professional cloud service focused on heterogeneous database schema migration. It can automatically convert the DDL, DML and DCL statements in source databases into SQL statements compatible with Huawei Cloud databases such as GaussDB and RDS. With the functions of database evaluation, object migration, and automatic syntax conversion, UGO can help you evaluate your reconstruction workload in advance, improve the conversion rate, and minimize the costs of database migration.

Functions

**Table 1** Functions
Function	Description	Reference
Database evaluation	UGO collects basic information and performance data of a source database, as well as SQL statements of specific object types, and provides an overview of the source database. Based on the analysis of factors such as compatibility and object complexity, UGO provides an analysis report on the compatibility and reconstruction cost of the source and target databases, helping you select a suitable target database and evaluate migration workloads.	Evaluation Project
Object migration	After the database evaluation is complete and the target database is confirmed, you can start to migrate database objects with a few clicks. In this module, UGO guides you to make a conversion plan and design a solution to automatically convert syntax. For objects that fail to be converted or migrated, you can edit and batch modify them to simplify manual reconstruction. Each modification is recorded, so that you can view and roll back historical modifications.	Migration Project
SQL audit	SQL audit helps users detect SQL standardization, design rationality, and performance issues hidden in code at the development phase. More than 200 audit rules are preset for various SQL statements such as DML, DDL, and PL/SQL. You can adjust the risk level, threshold, and suggestion in a rule and create a custom audit template by combining multiple rules. GaussDB and MySQL databases can be audited. You can use a single statement, upload code files in batches (SQL statements are automatically extracted), or directly connect to the database to audit SQL statements. UGO also prevents inappropriate SQL statements from flowing into the production environment.	SQL Audit

Billing

UGO is available for commercial use and is free for all users.

Solution

In heterogeneous database migration, UGO is used for schema migration and syntax conversion and Data Replication Service (DRS) for online data migration. UGO and DRS form a complete end-to-end heterogeneous database migration solution, helping you migrate data from mainstream commercial databases to Huawei Cloud databases easily and smoothly.

You can use UGO and DRS to migrate heterogeneous databases with complex stored procedures and functions to Huawei Cloud.

Figure 1 Database migration solution