Database and Application Migration UGO
Database and Application Migration UGO
All results for "
" in this service
All results for "
" in this service
What's New
Service Overview
UGO Infographics
What is UGO?
Functions
Highlights
Application Scenarios
Basic Concepts
Supported Database Versions
Constraints
Security
Compliance Description
Permission Management
Relationship Between UGO and Other Services
Getting Started
Database Evaluation
Preparations
Creating an Evaluation Project
Viewing the Database Evaluation Result
Database Schema Migration
Creating a Migration Project
Database Migration and Verification
SQL Audit
Creating a Data Source
Creating a Rule Template
Creating an Audit Task
Creating a Text Audit Task
Creating a File Audit Task
Creating a Database Audit Task
User Guide
Database Evaluation
Viewing Data Collection Logs
Re-Collecting Objects
Re-Evaluating a Project
Performing an Incremental Evaluation
Resuming a Stopped Project
Running Differentiation Analysis and Viewing the Generated Report
Managing a Tag
Deleting an Evaluation Project
Object Migration
Object Migration Implementation
Making a Conversion Plan
Setting Conversion Configuration Items
Converting Syntax
Correcting Objects
Verifying Migration Results
Object Migration Project Management
Deleting an Object Migration Project
Viewing Object Migration Details
Migration Pre-check
Checking the Compatibility Mode
Checking Character Sets
Checking GUC Parameters
Checking User Permissions
Setting Check Items
Converting Syntax
Converting Data Types
From MySQL to GaussDB
From Oracle to GaussDB
From PostgreSQL to GaussDB
From Microsoft SQL Server to GaussDB
SQL Statement Conversion
Conversion Configuration
Creating a Configuration Template
Exporting a Conversion Configuration Template
Viewing Conversion Configuration Templates
Modifying a Conversion Configuration Template
Deleting a Conversion Configuration Template
SQL Audit
Statement Audit
Viewing Text Audit History
Deleting All Audit Records
Viewing File Details
Viewing Error Files
Deleting a File Audit Task
Database Audit
Querying Audit Task Details
Deleting an Audit Task
Rules
Viewing Rule Template Details
Copying a Rule Template
Exporting a Rule Template
Deleting a Rule Template
Viewing System Rule Details
Data Source Management
Testing Data Source Connection
Deleting a Data Source
Modifying a Data Source
Syntax Conversion
Preparing a GaussDB Database
GaussDB (Oracle-Compatible Mode)
GaussDB (MySQL-Compatible Mode)
GaussDB (M-Compatible Mode)
Data Type Conversion
From Oracle to GaussDB
From MySQL to GaussDB
From PostgreSQL to GaussDB
From Microsoft SQL Server to GaussDB
Syntax Conversion
GaussDB Common Syntax
From Oracle to GaussDB
From PostgreSQL to GaussDB
From Microsoft SQL Server to MySQL
Conversion Error Codes
Common Conversion Error Codes
U0000001: GaussDB Distributed does not support generated columns in tables
U0000002: GaussDB Distributed does not support foreign key constraints
U0000003: GaussDB view does not support WITH CHECK OPTION
U0000004: GaussDB foreign key referenced columns must be a primary or unique key
U0000005: The length of the object name exceeds the upper limit allowed by GaussDB
U0000006:GaussDB does not support XXX as a column name of the table
U0000007: GaussDB Distributed does not support subpartitions
U0000008: GaussDB Distributed unique keys must be a superset of distribution keys
Error Codes Generated During Conversion from Oracle to GaussDB
U0100069: GaussDB does not support the system function
U0100070: When GaussDB uses the plus sign (+) operator, a table cannot correspond to multiple foreign tables
U0100071: Dynamic SQL statements cannot be automatically converted
U0100072: GaussDB does not support JSON_VALUE
U0100073: GaussDB does not have a function equivalent to SYS_OP_MAP_NONNULL
U0100074: GaussDB does not support level-2 partitions in interval partitions
U0100075: GaussDB does not support multiple hash keys
U0100076: Functions cannot be used in GaussDB hierarchical queries
U0100077: GaussDB does not support XMLTABLE
U0100078: GaussDB does not support DISTINCT in LISTAGG
U0100079: GaussDB supports FOR UPDATE OF followed by a table name only
U0100080: The column type cannot be determined. For BLOB or CLOB data types, manually add UPDATE after DBE_LOB.LOB_WRITE
U0100081: GaussDB does not support DBMS_SQL.TO_REFCURSOR
U0100082: GaussDB does not support DBMS_SQL.GET_NEXT_RESULT
U0100083: GaussDB does not support DBMS_SQL.RETURN_RESULT
U0100084: GaussDB does not support DBMS_SQL.TO_CURSOR_NUMBER
U0100085: GaussDB does not support subqueries in TABLE
U0100086: GaussDB does not support the ANYDATA data type
U0100087: The precision of the returned value of DBE_UTILITY.GET_TIME in GaussDB and Oracle is different
U0100088: GaussDB does not support hierarchical queries
U0100016: GaussDB does not support autonomous transactions in triggers
Error Codes Generated During Conversion from MySQL to GaussDB
U0400001: The GaussDB table attribute does not support this character set
U0400002: The GaussDB table attribute does not support this collation
U0400003: The GaussDB column definition does not support ON UPDATE
U0400004: The GaussDB view does not support SECURITY
U0400005: GaussDB does not support a specified definer during object creation
U0400006: GaussDB does not support SELECT in a stored procedure
U0400007: EXECUTE cannot be used to execute a dynamic SELECT statement in a GaussDB stored procedure
U0400008: GaussDB schema name cannot be specified when ALTER TABLE is used to rename a table
U0400009: GaussDB does not support the xxx system privilege
U0400010: GaussDB Distributed does not support AUTO_INCREMENT
U0400011: GaussDB auto_increment column must be the first field of a primary key constraint or unique constraint
U0400012: GaussDB temporary tables do not support AUTO INCREMENT
U0400013: GaussDB HASH partition keys cannot be specified in multiple columns
U0400014: GaussDB does not support the same partition key of child and parent partitions
U0400017:GaussDB stored procedures do not support CONTINUE HANDLER
U0400019: Multiple GaussDB tables cannot be updated or deleted
U0400020: GaussDB does not support INSERT ON DUPLICATE KEY UPDATE for primary or unique keys
U0400021: GaussDB does not support INSERT ON DUPLICATE KEY UPDATE for tables with GSIs
U0400022: Some GaussDB time functions do not support input parameters of the TIME or TIMETZ data type
U0400023: GaussDB does not support BINARY
U0400024: GaussDB does not support the ENUM data type
U0400025: GaussDB does not support the SET data type
U0400026: GaussDB does not support signed integers
U0400027: GaussDB does not support unsigned integers
U0400028: GaussDB does not support ZEROFILL integers
U0400029: GaussDB does not support a specified length of integers
U0400030: GaussDB does not support the LONGTEXT data type
U0400031: GaussDB does not support the LONGBLOB data type
U0400032: GaussDB partially supports the CONVERT function
U0400033: GaussDB does not support the system function
U0400035: GaussDB (M-compatible mode) does not support default value 0000-00-00 00:00:00 for TIMESTAMP data type
U0400036: GaussDB (M-compatible mode) does not support the JSON data type
U0400037: GaussDB does not support non-aggregation columns that are not in the GROUP BY clause in SELECT by default
U0400038: GaussDB does not support the SHOW command
U0400039: The default value definition for STRING data types in GaussDB (M-compatible mode) does not support "\0"(0x00)
U0400040: GaussDB (M-compatible mode) does not support the TABLE command
U0400041: GaussDB does not support ALTER DATABASE READ ONLY
U0400042: GaussDB (M-compatible mode) does not support ALTER TABLE CHECK CONSTRAINT ENFORCED
U0400043: GaussDB does not support ALTER INDEX VISIBLE
U0400044: GaussDB (M-compatible mode) does not support WINDOW in SELECT
U0400045: GaussDB (M-compatible mode) does not support stored procedures
U0400046: GaussDB (M-compatible mode) does not support storage functions
U0400047: GaussDB (M-compatible mode) does not support triggers
U0400048: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with UNION, INTERSECT, and EXCEPT
U0400049: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with DISTINCT
U0400050: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with GROUP BY and HAVING
U0400051: GaussDB (M-compatible mode) does not support SELECT FOR UPDATE, SELECT FOR SHARE, and LOCK IN SHARE MODE along with aggregate and window functions
U0400052: The reserved keyword is used as an identifier
U0400053: GaussDB (M-compatible mode) does not support this data type in CAST or CONVERT
U0400054: GaussDB does not support invisible columns
U0400055: GaussDB (M-compatible mode) does not support introducers of character set literals
U0400056: The table name is missing before FROM in DELETE
Error Codes Generated During Conversion from SQL Server to PostgreSQL
U0520001: The SMALLDATETIME data type in SQL Server is accurate to minute, while the TIMESTAMP (0) data type in PostgreSQL is accurate to second
U0520002: PostgreSQL does not support the time data type. If the decimal second precision exceeds 6, the time precision is lost
U0520003: The target database does not support the feature represented by the keyword
U0520004: The maximum sizes of data types related to SQL Server and PostgreSQL are incompatible
U0520005: In SQL Server, a data type does not need to be specified for computed columns. In PostgreSQL, a data type must be specified for generated columns. Set the data type of computed columns
Error Codes Generated During Conversion from PostgreSQL to GaussDB
U0600008: jsonb_extract_path does not support XXX as a parameter
Error Codes Generated During Conversion from GoldenDB to GaussDB
U0700001: The restriction on distribution columns in RANGE/LIST partition tables in GaussDB is different from that in GoldenDB. In GaussDB, the primary or unique key must be a superset of a distribution key
Error Codes Generated During Conversion from SQL Server to TaurusDB for PostgreSQL
U0530001: The target database does not support the feature represented by the keyword
U0530002: TaurusDB for PostgreSQL does not support variables in UPDATE
U0530003: TaurusDB for PostgreSQL does not support method names in UPDATE
U0530004: TOP does not work in INSERT...EXEC for TaurusDB for PostgreSQL
U0530005: TaurusDB for PostgreSQL does not support temporary stored procedures
Risky Custom Functions
Replacing Custom Oracle Functions with GaussDB Functions
months_between
instr
userenv
remainder
instrb
soundex
Replacing Custom MySQL Functions with GaussDB Functions
acos
asin
Error Codes
System Errors
UGO.10000000 Server internal error
Common Service Errors
UGO.10000001 Try again later
UGO.10001001 File type is not supported
UGO.10001002 File name exceeds limit
UGO.10001003 File size exceeds limit
UGO.10001004 File number exceeds limit
UGO.10001006 Invalid name
UGO.10001007 Invalid upload request
UGO.10001009 Failed to connect to the database
UGO.10001013 Invalid or incorrect SSL certificate
UGO.10001014 Target database cannot be MySQL
UGO.10001015 Invalid address or host name
UGO.10001016 The string length is incorrect
UGO.10001019 Failed to perform this operation
UGO.10001020 File cannot be uploaded
UGO.10001021 Insufficient disk space
UGO.10001022 Insufficient memory
UGO.10001023 Available disk space is less than 1 GB
UGO.10001024 Evaluation projects exceed limit
UGO.10001025 Failed to submit the task
UGO.10001026 Duplicate project name
UGO.10001027 No valid object is parsed from the SQL file
UGO.10001029 File description contains too many characters
UGO.10001030 No data available
UGO.10001032 Too frequent operations
UGO.10001033 File content exceeds limit
UGO.10001046 The file name contains special characters
UGO.10001037 Incorrect value
UGO.10001038 Failed to update the system configuration
UGO.10001039 Invalid schema name
UGO.10001040 Failed to generate the task ID
UGO.10001041 Unknown object status
UGO.10001042 Failed to save the file
UGO.10001043 The task does not exist or has timed out
UGO.10001044 Download requests exceed the limit
UGO.10001045 Unsupported language
Collection Errors
UGO.10010001 Incorrect number of database objects
UGO.10010002 Failed to check privileges
UGO.10010003 Failed to encrypt data
UGO.10010004 Failed to load the database certificate
UGO.10010005 Failed to collect database objects
UGO.10010008 No object is collected in the target database
UGO.10010009 Duplicate re-collection tasks
UGO.10010010 Failed to perform this operation on the SQL statement collection task
UGO.10010011 Failed to perform this operation on the table information collection task
Moving Errors
UGO.10050001 Incorrect migration status
UGO.10050003 The specified object conversion task is running
UGO.10050004 Failed to pre-check the migration task
UGO.10050005 Batch statement update rules exceed the upper limit
UGO.10050006 Failed to compile the regular expression
UGO.10050007 Migration report download timed out
UGO.10010012 Failed to perform this operation on the distribution column recommendation task
SQL Audit Errors
UGO.10100001 The SQL text file is too large
UGO.10100002 Password encryption or decryption error
UGO.10100005 The parameter is incorrect
UGO.10100006 The audit task queue is full
UGO.10100007 The number of rule templates has reached the limit
UGO.10100008 Incorrect threshold format
UGO.10100009 The task is terminated
UGO.10100010 Incorrect file format
UGO.10100011 Failed to connect to Kafka
UGO.10100012 The audit task is stopped due to UGO restart
UGO.10100013 The task file does not exist
UGO.10100014 Incorrect task parameter
UGO.10100015 No recommended indexes
UGO.10100016 The data source is in use
UGO.10100017 The SQL text size exceeds the limit
UGO.10100018 Too many requests
UGO.10100021 Custom rules exceed limit
UGO.10100022 Failed to compile the regular expression
Authentication Errors
UGO.10080002 No access privilege
UGO.10080005 No access privilege for the license
UGO.10080006 Access keys exceed the quota
Appendix
Checking Logs
Permissions Management
Creating a User and Granting Permissions
Creating a Custom Policy
Interconnection with CTS
Key Operations Recorded by CTS
Viewing Traces
Best Practices
Migrating Schemas from Oracle to GaussDB
Purpose
Resource Planning
Process Flow
Object Migration
Preparing for the Migration
Creating a GaussDB Instance
Creating a Database Evaluation Project
Creating an Object Migration Project
Migrating Objects
Checking the Migration Result
Security White Paper
Security White Paper
API Reference
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
API Types
Calling APIs
Making an API Request
Authentication
Response
API
API Version Management
Querying API Versions
Querying a Specified API Version
Quota Management
Querying Quota
SQL Statement Conversion
Converting SQL Statements
Evaluation Project
Creating an Evaluation Project
Querying Evaluation Projects
Querying the Status of an Evaluation Project
Querying Details About an Evaluation Project
Confirming the Target Database Type
Deleting an Evaluation Project
Migration Project
Creating a Migration Project
Querying Migration Projects
Querying the Status of a Migration Project
Checking Target Database Permissions
Querying Permission Check Results
Querying Migration Project Details
Submitting Syntax Conversion of Objects
Querying Syntax Conversion Progress of Objects
Submitting Verification
Querying the Verification Progress
Downloading a Migration Error Report
Deleting a Migration Project
Permissions Policies and Supported Actions
Permissions Policies and Supported Actions
UGO Actions
Appendixes
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
Obtaining an Account ID
SDK Reference
SDK Overview
FAQs
Product Consulting
Instance Freezing, Release, and Deletion
Which Schemas in Source Databases Are Ignored for Migration?
What Are the Differences Between Syntax Conversion and Migration & Verification in a Migration Project?
What Are the Database Schema Changes After an Oracle Database Is Migrated to the Target Database?
Why Cannot I Use Some Functions?
What Is the Function of the dsc_ora_ext Schema Generated After Migration to the Target Database?
What Should I Do If Data Collection Fails or Is Slow Due to the Small Values of Certain Oracle SGA Parameters?
What Should I Do If Data Collection Fails and a Message SNAPSHOT TOO OLD Is Displayed?
Database Connections
What Should I Do If I Cannot Connect to the Source Oracle Database During Database Evaluation Project Creation?
What Should I Do If I Failed To Connect to the Source Database as User sys?
How Do I Create GaussDB Databases Compatible with Source Databases?
What Should I Do If My Database Fails to be Connected?
SQL Server Connection Test Failed (Error Code=0, SQLState=08S01)
Evaluation Project
How Do I Select a Connection Method?
How Does UGO Collect Data from Source Databases?
How Does UGO Check Database Permissions?
Oracle as the Source
MySQL as the Source
GoldenDB as the Source
Microsoft SQL Server as the Source
PostgreSQL as the Source Database Type
What Are the Possible Causes for an Object Collection Failure?
In GaussDB, How Do I Configure a Search Path If A Statement Without Schema Name Fails To Be Executed?
What Is Native Compatibility, Conversion Compatibility, Partial Compatibility, or Incompatibility?
What Is the Relationship Between Migration Risk (Top 10 risk SQL) and Risky SQL Summary?
What Are Reconstruction Statistics and How Are Reconstruction Points Measured?
What Should I Do If An Object Collection Error (Closed Connection) Is Displayed During Evaluation Project Creation?
What Should I Do If "ErrorCode=4036" Is Displayed During Evaluation Project Creation?
What Should I Do If "ErrorCode=17002" Is Displayed During Evaluation Project Creation?
What Do I Do If the Assessment Task Is Connected but the Pre-check Fails?
What Is the Impact of the Collection on the Source Database?
Migration Project
Why Is There No Available Evaluation Project During Migration Project Creation?
When Should I Use the Conversion Config Function?
What Should I Do If SQL Modifications Failed to Be Saved During Object Correction?
How Do I Solve ERROR: syntax error at or near "@"?
What Are the Possible Causes for an Object Verification Failure?
What Are the Impacts of GUC Parameter Settings of GaussDB on Migration?
GUC Parameters of GaussDB (Oracle-Compatible Mode)
GUC Parameters of GaussDB (MySQL-Compatible Mode)
How Do I Set GaussDB GUC Parameters?
Why Is the Number of Indexes Different After Oracle Data is Migrated to GaussDB?
What Should I Do If There Are ctid, xc_node_id, and tableoid Columns in GaussDB?
Why Is Data Inconsistent When SELECT Statements Without ORDER BY Are Used for Query in Distributed GaussDB?
Videos
General Reference
Glossary
Service Level Agreement
White Papers
Endpoints
Permissions