Updated on 2024-11-08 GMT+08:00

Functions

Source Database Profiling

UGO efficiently collects database metadata such as various database object types and abstracts various types of information from them. This provides a sufficient data basis for accurate and quick analysis of important information such as application scenarios and user operation habits of the source database.

Target Database Compatibility Analysis

UGO uses a source database profile as the input to analyze the syntax compatibility of core database object types based on the selected destination database type. UGO analysis results include native compatibility, conversion compatibility, partial compatibility, and incompatibility. It then classifies and collects the analyses, lists the most incompatible syntax points, and provides reconstruction suggestions.

Workload Evaluation

UGO has incorporated extensive experience in migration and reconstruction through numerous real-world user service scenarios. It evaluates migration workloads based on factors such as the amount of code involved, the conversion rate, and how hard it will be to reconstruct incompatible features.

Database Schema Migration

UGO maximizes semantic equivalence for SQL syntaxes in source and target databases and then applies the converted SQL statements to the target database. Objects that are incompatible with the syntax and cannot be converted are marked as failed and a failure cause is provided. Manual correction is supported too. If needed, you can manually modify objects on UGO and then apply those modified statements to the target database in one-click.