Help Center/ Database and Application Migration UGO/ Service Overview/ Supported Database Versions
Updated on 2026-05-16 GMT+08:00
View PDF
Share

Supported Database Versions

Constraints

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

openGauss

1.0, 2.0, 3.0, 4.0, 5.0, 6.0, and 7.0

Source GoldenDB, MariaDB, and openGauss databases are only available to whitelisted users.

Evaluable Database Middleware

Table 2 lists the database middleware and versions supported by UGO.

Table 2 Supported database middleware and versions

Source Database Middleware

Source Database Middleware Version

DDM

-

Supported Data Flows and Target Database Versions

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

Table 3 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

GaussDB Centralized V2.0 (A-compatible)

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, 9.0 Enterprise Edition, 9.1 Enterprise Edition, and 10.0 Enterprise Edition

GaussDB Centralized V2.0 (A-compatible and multi-primary)

9.1 Enterprise Edition and 10.0 Enterprise Edition

GaussDB Distributed V2.0 (Oracle-compatible)

2.7 Enterprise Edition, 3.2 Enterprise Edition, 3.3 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, 9.0 Enterprise Edition, 9.1 Enterprise Edition, and 10.0 Enterprise Edition

GaussDB Distributed V2.0 (A-compatible and multi-primary)

9.1 Enterprise Edition and 10.0 Enterprise Edition

MySQL

GaussDB Centralized V2.0 (B-compatible)

2.7 Enterprise Edition, 3.1 Enterprise Edition, 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, 9.0 Enterprise Edition, 9.1 Enterprise Edition, and 10.0 Enterprise Edition

GaussDB Centralized V2.0 (M-compatible)

8.100 Enterprise Edition, 8.200 Enterprise Edition, 9.0 Enterprise Edition, 9.1 Enterprise Edition, and 10.0 Enterprise Edition

GaussDB Distributed V2.0 (MySQL-compatible)

2.7 Enterprise Edition, 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, 9.0 Enterprise Edition, 9.1 Enterprise Edition, and 10.0 Enterprise Edition

PostgreSQL

GaussDB Centralized V2.0 (A-compatible)

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

GaussDB Distributed V2.0 (Oracle-compatible)

3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition

GoldenDB

GaussDB Centralized V2.0 (B-compatible)

8.0 Enterprise Edition and 8.100 Enterprise Edition

GaussDB Centralized V2.0 (M-compatible)

8.200 Enterprise Edition and 9.0 Enterprise Edition

GaussDB Distributed V2.0 (MySQL-compatible)

8.0 Enterprise Edition and 8.100 Enterprise Edition

Microsoft SQL Server

GaussDB Centralized V2.0 (A-compatible)

3.1 Enterprise Edition, 3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, 9.0 Enterprise Edition, 9.1 Enterprise Edition, and 10.0 Enterprise Edition

GaussDB Centralized V2.0 (A-compatible and multi-primary)

9.1 Enterprise Edition and 10.0 Enterprise Edition

GaussDB Distributed V2.0 (Oracle-compatible)

3.2 Enterprise Edition, 8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, 9.0 Enterprise Edition, 9.1 Enterprise Edition, and 10.0 Enterprise Edition

GaussDB Distributed V2.0 (A-compatible and multi-primary)

9.1 Enterprise Edition and 10.0 Enterprise Edition

TaurusDB

RDS for PostgreSQL

11, 12, 13, 14, and 15

TaurusDB for PostgreSQL

16.4

MariaDB

GaussDB Centralized V2.0 (A-compatible)

9.0 Enterprise Edition

openGauss

GaussDB Centralized V2.0 (A-compatible)

8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition

GaussDB Distributed V2.0 (Oracle-compatible)

8.0 Enterprise Edition, 8.100 Enterprise Edition, 8.200 Enterprise Edition, and 9.0 Enterprise Edition

DDM

GaussDB Distributed V2.0 (MySQL-compatible)

8.200 Enterprise Edition, 9.0 Enterprise Edition, 9.1 Enterprise Edition, and 10.0 Enterprise Edition
  • The target GaussDB instance V2.0-10.0 Enterprise Edition is only available to whitelisted users.
  • The target GaussDB instance V2.0-9.1 Enterprise Edition is only available to whitelisted users.
  • The target GaussDB instance V2.0-9.0 Enterprise Edition is only available to whitelisted users.
  • When GaussDB is used as the destination 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, select V2.0-2.7 Enterprise Edition for migration. 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 4 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'

Event

Event objects

PostgreSQL

Schema

information_schema and a system schema prefixed with pg_, for example, pg_catalog, pg_toast, or pg_temp_1

Grant

Table GRANT privileges

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'

Event

Event objects

openGauss

Schema

'blockchain', 'coverage', 'cstore', 'db4ai', 'dbe_perf', 'dbe_pldebugger', 'dbe_pldeveloper', 'dbe_sql_util', 'information_schema', 'pg_catalog', 'pg_toast', 'pkg_service', 'snapshot', 'sqladvisor'