Help Center/ Database and Application Migration UGO/ Service Overview/ Supported Database Versions

Updated on 2025-12-23 GMT+08:00

View PDF

Supported Database Versions

Constraints

Currently, some source and destination databases can be used only by whitelisted users. To use them, choose Service Tickets > Create Service Ticket in the upper right corner of the console to submit a request.
When selecting GaussDB as the target database type, you need to create a GaussDB database compatible with the source database.

Supported Source Database Types and Versions

Table 1 lists source database types and versions supported by UGO.

**Table 1** Source database types and versions
Source DB Engine	Source DB Version
Oracle	10g, 11g, 12c, 18c, 19c, and 21c
MySQL	5.5, 5.6, 5.7, and 8.0
PostgreSQL	10, 11, 12, 13, 14, and 15
GoldenDB	-
Microsoft SQL Server	2012, 2014, 2016, 2017, 2019, and 2022
MariaDB	10.6

GoldenDB and MariaDB as the source are available only to whitelisted users.

Supported Data Flows and Target Database Versions

Table 2 lists data flows supported by UGO and target database types and versions.

**Table 2** Supported data flows and target database types and versions
Source DB Engine	Target DB Type and Version
Oracle	RDS for MySQL 5.7
	RDS for PostgreSQL 11, 12, 13, and 14
	TaurusDB
	Centralized GaussDB instance V2.0 (A-compatible mode) 2.7 Enterprise Edition, 3.1 Enterprise Edition, 3.2 Enterprise Edition, 3.3 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition
	Distributed GaussDB instance V2.0 (Oracle-compatible mode) 2.7 Enterprise Edition, 3.2 Enterprise Edition, 3.3 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition
MySQL	Centralized GaussDB instance V2.0 (B-compatible mode) 2.7 Enterprise Edition, 3.1 Enterprise Edition, 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, and 8.200 Enterprise Edition
	Centralized GaussDB instance V2.0 (M-compatible mode) 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition
	Distributed GaussDB instance V2.0 (MySQL-compatible mode) 2.7 Enterprise Edition, 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, and 8.200 Enterprise Edition
PostgreSQL	Centralized GaussDB instance V2.0 (A-compatible mode) 3.1 Enterprise Edition, 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition
PostgreSQL	Distributed GaussDB instance V2.0 (Oracle-compatible mode) 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition
GoldenDB	Centralized GaussDB instance V2.0 (B-compatible mode) 8.0 Enterprise Edition and 8.100 Enterprise Edition
	Centralized GaussDB instance V2.0 (M-compatible mode) 8.200 Enterprise Edition and 9.0 Enterprise Edition
	Distributed GaussDB instance V2.0 (MySQL-compatible mode) 8.0 Enterprise Edition and 8.100 Enterprise Edition
Microsoft SQL Server	Centralized GaussDB instance V2.0 (A-compatible mode) 3.1 Enterprise Edition, 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition
	Distributed GaussDB instance V2.0 (Oracle-compatible mode) 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition
	TaurusDB
	RDS for PostgreSQL 11, 12, 13, 14, and 15
	TaurusDB for PostgreSQL 16.4
MariaDB	Centralized GaussDB instance V2.0 (A-compatible mode) 9.0 Enterprise Edition

GaussDB V2.0-9.0 Enterprise Edition as the target database are available only to whitelisted users.
When GaussDB is used as the target database, its versions earlier than V2.0-2.7 are not displayed on UGO. If GaussDB V2.0-2.1 or V2.0-2.2 Enterprise Edition is used, migrate it to V2.0-2.7 Enterprise Edition. Instances of GaussDB in versions earlier than V2.0-2.1 cannot be migrated by UGO, so you need to upgrade the version.

No Collection from Source Databases

**Table 3** No collection from source database objects
Source DB Engine	Object Type	Not Collected by UGO
Oracle	Schema	'APEX_050000', 'AUDSYS', 'ADAMS', 'ANONYMOUS', 'AURORA$ORB$UNAUTHENTICATED', 'AWR_STAGE', 'APEX_030200', 'APEX_040200', 'APEX_PUBLIC_USER', 'APPQOSSYS', 'BLAKE', 'CLARK', 'CSMIG', 'CTXSYS', 'DBSNMP', 'DIP', 'DMSYS', 'DSSYS', 'DEMO', 'DVSYS', 'DVF', 'DBSFWUSER', 'EXFSYS', 'FLOWS_FILES', 'GGSYS', 'GSMADMIN_INTERNAL', 'GSMCATUSER', 'GSMUSER', 'JONES', 'LBACSYS', 'MDDATA', 'MDSYS', 'MGMT_VIEW', 'OLAPSYS', 'ORACLE_OCM', 'ORDDATA', 'ORDPLUGINS', 'ORDSYS', 'OUTLN', 'OWBSYS', 'OWBSYS_AUDIT', 'OJVMSYS', 'PERFSTAT', 'REMOTE_SCHEDULER_AGENT', 'SI_INFORMTN_SCHEMA', 'SPATIAL_CSW_ADMIN_USR', 'SPATIAL_WFS_ADMIN_USR', 'SYS', 'SYSMAN', 'SPATIAL_CSW_ADMIN_USR', 'SYSBACKUP', 'SYSKM', 'SYSDG', 'SYSRAC', 'SYS$UMF', 'SYSTEM', 'TRACESVR', 'TSMSYS', 'WMSYS', 'XDB', 'XS$NULL', 'GSMROOTUSER'
	Table	Tables generated by the system, for example, SYS_EXPORT_SCHEMA_% System objects whose names start with SYS_PLSQL Deleted objects whose names start with BIN$ Tables that are automatically generated by data pump jobs and recorded in the DBA_DATAPUMP_JOBS or USER_DATAPUMP_JOBS view
	JOB	System job objects whose names start with DBMS_JOB$_
	Index	Indexes generated by primary keys and unique constraints
MySQL	Schema	'INFORMATION_SCHEMA', 'MYSQL', 'PERFORMANCE_SCHEMA', 'SYS'
MySQL	Event	Event objects
Db2 for LUW	Schema	'NULLID', 'SQLJ', 'SYSCAT', 'SYSFUN', 'SYSIBM', 'SYSIBMADM', 'SYSIBMINTERNAL', 'SYSIBMTS', 'SYSPROC', 'SYSPUBLIC', 'SYSSTAT', 'SYSTOOLS'
PostgreSQL	Schema	information_schema and a system schema prefixed with pg_, for example, pg_catalog, pg_toast, or pg_temp_1
PostgreSQL	Grant	Table authorization information
Microsoft SQL Server	Schema	'GUEST', 'INFORMATION_SCHEMA', 'SYS', 'DB_OWNER', 'DB_ACCESSADMIN', 'DB_SECURITYADMIN', 'DB_DDLADMIN', 'DB_BACKUPOPERATOR', 'DB_DATAREADER', 'DB_DATAWRITER', 'DB_DENYDATAREADER', 'DB_DENYDATAWRITER'
	Table	Partitioned tables and file groups Encrypted columns with the ENCRYPTED WITH clause Computed columns with the AS clause Sparse columns COLLATE character sets specified in columns GENERATED ALWAYS
	CLR	CLR functions CLR stored procedures CLR triggers CLR user-defined types
	XML Schema COLLECTION	XML schema collection
	Trigger	Database triggers Server triggers
	Index	JSON indexes XML indexes Spatial indexes Full-text indexes Ordering of common index columns INCLUDE of common index columns WHERE of common index columns
MariaDB	Schema	'INFORMATION_SCHEMA', 'MYSQL', 'PERFORMANCE_SCHEMA', 'SYS'
MariaDB	Event	Event objects

Previous topic: Basic Concepts

Next topic: Constraints

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.