HUAWEI CLOUD UGO: Wake up! Your heterogeneous database migration problem is saved

Abstract: The database and application migration UGO launched by HUAWEI CLOUD is a professional cloud service that focuses on heterogeneous database structure migration and application SQL conversion.
In the digital age, going to the cloud has become the basic consensus of business managers. With the rapid changes in technology, going to the cloud has become easier and simpler. However, the migration of heterogeneous databases is still a major challenge in the industry because it involves extremely complex and intriguing challenges. Compatibility headaches. For heterogeneous database migration, problems such as migration assessment, object compatibility, grammatical transformation, and object optimization are like mountains that are difficult to cross. "Inability to move, immovability, and high cost" have always been the pain points of heterogeneous database migration. In fact, if you want to move well and move steadily, professional migration tools are indispensable. The database and application migration UGO launched by Huawei Cloud is a professional cloud service that focuses on the migration of heterogeneous database structures and application SQL conversion. It can help users identify migration risks in advance through pre-migration evaluation and automatic syntax conversion, improve migration efficiency, minimize the user's database migration cost, and easily realize the automated migration of mainstream commercial databases to Huawei Cloud databases. Specifically, Huawei Cloud UGO has the following five core capabilities:

Database source database portrait positioning: Fully collect source database data information (such as TPS, QPS, table complexity, etc.), accurately locate the full picture of source database information, and provide a sufficient data basis for analyzing source database application scenarios, user operating habits and other important information.

Target library compatibility analysis: As one of the core modules of HUAWEI CLOUD UGO migration capabilities, this module performs compatibility analysis and migration risks for the 14 core object types of the target library based on the image positioning of the source library and a comprehensive syntax conversion rate of up to 85% Assess what can be supported and what is not, and the results are clear at a glance. For those that are not supported, HUAWEI CLOUD UGO also provides suggestions for improvement.

Migration workload assessment: Accurately assess the migration costs such as manpower, massive scene input, and difficulty of compatibility transformation, and comprehensively output the migration workload, so that customers have a quantitative perception of the overall migration work.

Target library selection and specification recommendation: According to the source library image input, comprehensive compatibility, performance, object complexity, usage scenarios, etc., intelligently recommend the appropriate target library selection and priority, as well as the specifications and costs under different selections, Let customers choose peace of mind.

Database structure migration: Structure migration is the core module of HUAWEI CLOUD UGO migration capabilities. This module directly converts various types of SQL in the source database into SQL syntax on the target end, and supports filtering out invalid objects/objects that do not need to be migrated. After the conversion is completed Mark the conversion failure object and the failure reason. The user can correct the object according to the failure reason. After the correction, the verification test is performed. The verification failure object can be re-modified and submitted for verification multiple times. The entire migration implementation process will not end until all the objects are successfully verified. Moreover, the entire migration process is visualized and automated, which truly saves worry and effort.

In terms of application practice, Huawei Cloud UGO is widely used in migration and transformation scenarios in the financial, Internet, government and other fields, and has obtained excellent practices in Huawei’s process IT projects. Huawei's process IT has hundreds of thousands of tables, stored process codes over 100 million, and the amount of migrated data is up to several terabytes. Through migration assessment and SQL conversion, Huawei Cloud UGO helped Huawei's process IT migration cycle to be shortened from day to hour, reduced storage process transformation costs by 50%, saved 70%+ workload, and efficiently supported Huawei's process IT Digital transformation.

It is worth mentioning that Huawei Cloud UGO won the DTCC2020 "Best Innovative Solution of the Year Award" for its outstanding technical hard power, and passed the 2021 "Database Application Migration Service Capability" evaluation by the Institute of Information and Communications Technology, and won the industry authority. Recognized. The technology is endless. Huawei Cloud UGO, which insists on innovation and continues to cultivate technology, will be even better in the future!

Ps: Currently, Huawei Cloud UGO is in the hot public beta. Welcome everyone to experience it for free >> https://www.huaweicloud.com/product/ugo.html

Click to follow and learn about Huawei Cloud's fresh technology for the first time~