What database types and features does DMS support-Data Management-阿里云帮助中心

Supported database types

Alibaba Cloud databases

Relational databases

ApsaraDB RDS for MySQL
ApsaraDB RDS for SQL Server
ApsaraDB RDS for PostgreSQL
ApsaraDB for MariaDB
PolarDB for MySQL
PolarDB for PostgreSQL
PolarDB for PostgreSQL (Compatible with Oracle)
PolarDB for Xscale (formerly DRDS)
ApsaraDB for OceanBase in MySQL mode
ApsaraDB for OceanBase in Oracle mode
ApsaraDB RDS for PPAS

Data warehouses

ApsaraDB for ClickHouse
AnalyticDB for MySQL 3.0
AnalyticDB for PostgreSQL
AnalyticDB for MySQL 2.0

NoSQL databases

Tair (Redis OSS-Compatible)
ApsaraDB for MongoDB

ApsaraDB for MongoDB Serverless Edition is not supported.
ApsaraDB for Cassandra
Lindorm SQL
Lindorm Phoenix
Lindorm CQL
Lindorm TSDB
Lindorm HBase
Graph Database

Big data

MaxCompute
MaxCompute Lighting

Feature	MaxCompute	Hologres	RestAPI
Query	✔️	✔️	❌
Logical database and table query	❌	❌	❌
Cross-database query	❌	❌	❌
SQL result set export	✔️	✔️	❌
Table data export	❌	❌	❌
Data change	✔️	✔️	❌
Data import	❌	✔️	❌
Test data generation	❌	❌	❌
Database clone	❌	❌	❌
Schema evolution	❌	❌	❌
Visual schema editing	❌	❌	❌
Schema synchronization	❌	❌	❌
Empty database initialization	❌	❌	❌
Programmable object	❌	❌	❌
Schema export	❌	❌	❌
Schema Design Pro	❌	❌	❌
Database creation	❌	❌	❌
Database user creation	❌	❌	❌
SQL review	❌	❌	❌
Sensitive data management	✔️	✔️	❌
Permission system	✔️	✔️	✔️
Operation logs	✔️	✔️	❌
DataService Studio	✔️	✔️	❌
Data visualization	✔️	✔️	❌
Task orchestration	✔️	✔️	✔️
Data warehouse development	❌	❌	❌
Ticket system	✔️	✔️	❌
Security rules	✔️	✔️	❌
Approval process	✔️	✔️	❌

Feature	SLS	S3	OSS
Query	✔️	❌	✔️
Logical database and table query	❌	❌	❌
Cross-database query	❌	❌	❌
SQL result set export	✔️	❌	❌
Table data export	❌	❌	❌
Data change	❌	❌	❌
Data import	❌	❌	❌
Test data generation	❌	❌	❌
Database clone	❌	❌	❌
Schema evolution	❌	❌	❌
Visual schema editing	❌	❌	❌
Schema synchronization	❌	❌	❌
Empty database initialization	❌	❌	❌
Programmable object	✔️	❌	❌
Schema export	❌	❌	❌
Schema design PRO	❌	❌	❌
Database creation	❌	❌	❌
Database user creation	❌	❌	❌
SQL review	❌	❌	❌
Sensitive data management	❌	❌	❌
Permission system	✔️	✔️	✔️
Operation logs	✔️	❌	❌
DataService Studio	❌	❌	❌
Data visualization	❌	❌	❌
Task orchestration	❌	✔️	✔️
Data warehouse development	❌	❌	❌
Ticket system	❌	❌	❌
Security rules	❌	❌	❌
Approval process	❌	❌	❌

File and log service

OSS
Log Service

Third-party cloud and self-managed databases

Relational databases

MySQL
SQL Server
PostgreSQL
MariaDB
ApsaraDB for OceanBase in MySQL mode
ApsaraDB for OceanBase in Oracle mode
OceanBase ODP
Oracle
Db2
Dameng
openGauss

Data warehouse

ApsaraDB for ClickHouse

NoSQL databases

Tair (Redis OSS-Compatible)
ApsaraDB for MongoDB

Big data

BigQuery

Feature support by database type

Symbol key:

Symbol	Meaning
✔️	Supported
➖	Coming soon
❌	Not supported

Relational databases

Data operations

Feature	MySQL (excl. PolarDB-X)	PolarDB-X	SQL Server	PostgreSQL (excl. PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB for OceanBase in MySQL mode	Self-managed Oracle and ApsaraDB for OceanBase in Oracle mode	PolarDB for PostgreSQL (Compatible with Oracle)	DamengDB
Query	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Query for logical databases or collections	✔️	❌	✔️	✔️	✔️	➖	✔️	✔️	✔️	❌
Cross-instance query	✔️	✔️	✔️	✔️	✔️	❌	❌	❌	✔️	❌
SQL result set export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Table data export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️
Data change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Historical data cleanup	✔️	✔️	❌	✔️	✔️	✔️	✔️	❌	✔️	✔️
Lock-free data change	✔️	✔️	❌	✔️	✔️	✔️	✔️	❌	✔️	❌
Data import	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️
Test data generation	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	❌
Data tracking	✔️	➖	❌	❌	❌	➖	❌	❌	➖	❌

Schema management

Feature	MySQL (excl. PolarDB-X)	PolarDB-X	SQL Server	PostgreSQL (excl. PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB for OceanBase in MySQL mode	Self-managed Oracle and ApsaraDB for OceanBase in Oracle mode	PolarDB for PostgreSQL (Compatible with Oracle)	DamengDB
Schema change	✔️	✔️	✔️	✔️	✔️	✔️	✔️	❌	✔️	❌
Visualized schema modification	✔️	✔️	✔️	✔️	✔️	✔️	❌	❌	✔️	❌
Lock-free schema change	✔️	➖	❌	❌	❌	➖	❌	❌	❌	❌
Schema synchronization	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌
Schema export	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Schema design pro	✔️	✔️	❌	❌	➖	➖	✔️	❌	➖	❌
Database cloning	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌
Empty database initialization	✔️	✔️	❌	➖	➖	✔️	✔️	❌	➖	❌
Programmable object	✔️	❌	✔️	✔️	✔️	✔️	❌	❌	✔️	❌
Database creation	✔️	❌	❌	➖	❌	✔️	❌	❌	❌	❌
Database user creation	✔️	❌	❌	➖	❌	✔️	❌	❌	❌	❌

SQL analysis and diagnostics

Feature	MySQL (excl. PolarDB-X)	PolarDB-X	SQL Server	PostgreSQL (excl. PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB for OceanBase in MySQL mode	Self-managed Oracle and ApsaraDB for OceanBase in Oracle mode	PolarDB for PostgreSQL (Compatible with Oracle)	DamengDB
SQL review	✔️	➖	❌	✔️	✔️	➖	➖	✔️	✔️	❌
SQL and instance diagnostics	✔️	❌	❌	✔️	✔️	➖	❌	❌	✔️	❌

Security and governance

Feature	MySQL (excl. PolarDB-X)	PolarDB-X	SQL Server	PostgreSQL (excl. PolarDB for PostgreSQL)	PolarDB for PostgreSQL	MariaDB	ApsaraDB for OceanBase in MySQL mode	Self-managed Oracle and ApsaraDB for OceanBase in Oracle mode	PolarDB for PostgreSQL (Compatible with Oracle)	DamengDB
Sensitive data management	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Access control system	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Operation logs	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
DataService Studio	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Data warehouse development	✔️	✔️	❌	❌	❌	❌	❌	❌	❌	❌
Security rules	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Task orchestration	✔️	✔️	✔️	✔️	✔️	❌	✔️	✔️	✔️	✔️
Ticket system	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Approval process	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️	✔️

Data warehouses

Feature	AnalyticDB for MySQL 2.0	AnalyticDB for MySQL 3.0	AnalyticDB for PostgreSQL	ClickHouse
Query	✔️	✔️	✔️	✔️
Query for logical databases or collections	❌	✔️	✔️	❌
Cross-instance query	❌	✔️	✔️	❌
SQL result set export	✔️	✔️	✔️	✔️
Table data export	❌	✔️	✔️	❌
Data change	✔️	✔️	✔️	✔️
Data import	✔️	✔️	✔️	❌
Test data generation	✔️	✔️	✔️	❌
Database cloning	❌	❌	➖	❌
Schema change	❌	✔️	✔️	✔️
Visualized schema modification	❌	✔️	✔️	❌
Schema synchronization	❌	✔️	➖	❌
Empty database initialization	❌	✔️	➖	❌
Programmable object	❌	❌	✔️	❌
Schema export	✔️	✔️	✔️	❌
Schema design pro	❌	❌	➖	❌
Database creation	❌	➖	➖	❌
Database user creation	❌	➖	➖	❌
SQL review	❌	➖	➖	❌
Sensitive data management	✔️	✔️	✔️	❌
Access control system	✔️	✔️	✔️	✔️
Operation logs	✔️	✔️	✔️	✔️
DataService Studio	✔️	✔️	✔️	❌
Task orchestration	✔️	✔️	✔️	❌
Ticket system	✔️	✔️	✔️	✔️
Security rules	✔️	✔️	✔️	✔️
Approval process	✔️	✔️	✔️	✔️

NoSQL databases

Feature	MongoDB	Redis	Lindorm	Cassandra	GDB
Query	✔️	✔️	✔️	✔️	✔️
Cross-instance query	❌	✔️	❌	❌	❌
SQL result set export	✔️	❌	✔️	✔️	❌
Table data export	❌	❌	➖	➖	❌
Data change	✔️	✔️	✔️	✔️	✔️
Schema change	❌	❌	✔️	✔️	❌
Database creation	✔️	❌	❌	❌	❌
Database user creation	✔️	❌	❌	❌	❌
SQL review	✔️	❌	❌	❌	❌
SQL and instance diagnostics	✔️	✔️	❌	❌	❌
Sensitive data management	❌	❌	✔️	➖	❌
Access control system	✔️	✔️	✔️	✔️	✔️
Operation logs	✔️	✔️	✔️	✔️	✔️
Ticket system	✔️	✔️	✔️	✔️	✔️
Security rules	✔️	✔️	✔️	✔️	✔️
Approval process	✔️	✔️	✔️	✔️	✔️

Big data

Feature	MaxCompute	Hologres	RestAPI
Query	✔️	✔️	❌
Query for logical databases or collections	❌	❌	❌
Cross-instance query	❌	❌	❌
SQL result set export	✔️	✔️	❌
Table data export	❌	❌	❌
Data change	✔️	✔️	❌
Data import	❌	✔️	❌
Test data generation	❌	❌	❌
Database cloning	❌	❌	❌
Schema change	❌	❌	❌
Visualized schema modification	❌	❌	❌
Schema synchronization	❌	❌	❌
Empty database initialization	❌	❌	❌
Programmable object	❌	❌	❌
Schema export	❌	❌	❌
Schema design pro	❌	❌	❌
Database creation	❌	❌	❌
Database user creation	❌	❌	❌
SQL review	❌	❌	❌
Sensitive data management	✔️	✔️	❌
Access control system	✔️	✔️	✔️
Operation logs	✔️	✔️	❌
Task orchestration	✔️	✔️	✔️
Ticket system	✔️	✔️	❌
Security rules	✔️	✔️	❌
Approval process	✔️	✔️	❌

File and log service

Feature	SLS	OSS
Query	✔️	✔️
Query for logical databases or collections	❌	❌
Cross-instance query	❌	❌
SQL result set export	✔️	❌
Table data export	❌	❌
Data change	❌	❌
Data import	❌	❌
Test data generation	❌	❌
Database cloning	❌	❌
Schema change	❌	❌
Visualized schema modification	❌	❌
Schema synchronization	❌	❌
Empty database initialization	❌	❌
Programmable object	✔️	❌
Schema export	❌	❌
Schema design pro	❌	❌
Database creation	❌	❌
Database user creation	❌	❌
SQL review	❌	❌
Sensitive data management	❌	❌
Access control system	✔️	✔️
Operation logs	✔️	❌
Task orchestration	❌	✔️
Ticket system	❌	❌
Security rules	❌	❌
Approval process	❌	❌

Data Disaster Recovery (formerly DBS) — supported database types

Important

If the data source contains Chinese table names or field names, data recovery fails. Join the DingTalk group (ID: 35585947) to report the issue or submit a ticketsubmit a ticket.

Data Disaster Recovery supports the following database categories:

Relational databases: Alibaba Cloud databases; self-managed databases on Elastic Compute Service (ECS) instances; on-premises databases; third-party cloud databases
NoSQL databases: MongoDB, Redis
Logical backup: MySQL, MariaDB, PolarDB (for PostgreSQL, for MySQL, for PostgreSQL Compatible with Oracle, and PolarDB-X), SQL Server, Oracle, Redis, MongoDB

Disaster recovery data source

The disaster recovery data source module supports creating backups from:

Alibaba Cloud databases: ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, ApsaraDB RDS for SQL Server, and PolarDB for MySQL
Self-managed databases on ECS instances: MySQL
On-premises and third-party cloud databases: MySQL

Data Disaster Recovery feature support by database type

Relational databases — Alibaba Cloud

Logical backup

Operation	ApsaraDB RDS for MySQL	ApsaraDB RDS for SQL Server	ApsaraDB RDS for PostgreSQL	ApsaraDB RDS for MariaDB	PolarDB for MySQL	PolarDB for PostgreSQL	PolarDB-X
Supported versions	8.0, 5.7, 5.6, 5.5	2019, 2017, 2016, 2014, 2012, 2008 R2	16, 15, 14, 13, 12, 11, 10, 9.4	10.3	8.0, 5.7, 5.6	11	Storage type: ApsaraDB RDS for MySQL (MySQL 5.x)
Data source type	MySQL	SQL Server	PostgreSQL	MariaDB	MySQL	Oracle, PostgreSQL	PolarDB-X
Full data backup	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Incremental log backup	✔️	❌	❌	✔️	✔️	❌	❌
Real-time backup	RPO in seconds	RPO in days	RPO in days	RPO in seconds	RPO in seconds	RPO in days	RPO in days
Instance restoration	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Minimum granularity	Tables	Tables	Tables	Tables	Tables	Tables	Database
Backup set download	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Backup set query	✔️	✔️	✔️	❌	✔️	✔️ (PostgreSQL data source only)	✔️

Recovery Point Objective (RPO) is the maximum acceptable data loss measured as the point in time to which data can be restored after a disaster.

Cross-account backup and restore is supported for Alibaba Cloud databases. For details, see Back up and restore data across Alibaba Cloud accounts.

Relational databases — self-managed and third-party cloud

Logical backup

Operation	MySQL	SQL Server	Oracle	PostgreSQL	MariaDB
Supported versions	8.0, 5.7, 5.6, 5.5	2019, 2017, 2016, 2014, 2012, 2008 R2, and 2005 on Windows	12c, 11g, 10g, 9i	11, 10, 9.5, 9.4, 9.3	10.3, 10
Data source type	MySQL	SQL Server	Oracle	PostgreSQL	MariaDB
Full data backup	✔️	✔️	✔️	✔️	✔️
Incremental log backup	✔️	❌	❌	❌	✔️
Real-time backup	RPO in seconds	RPO in days	RPO in days	RPO in days	RPO in seconds
Instance restoration	✔️	✔️	✔️	✔️	✔️
Minimum granularity	Tables	Tables	Tables	Tables	Tables
Backup set download	✔️	✔️	✔️	✔️	✔️
Backup set query	✔️	✔️	✔️	✔️	❌

Physical backup

Operation	MySQL	SQL Server	Oracle
Supported versions	8.0, 5.7, 5.6, 5.5 (Linux)	2019, 2017, 2016, 2014, 2012, 2008 R2, 2005, 2000	11g, 10g, 12c, 18c, 19c
Data source type	MySQL	SQL Server	Oracle
Full data backup	✔️	✔️	✔️
Incremental log backup	✔️ (binary logs; see Back up binary logs of a MySQL database)	✔️	✔️
Differential backup	✔️	❌	❌
Instance restoration	✔️	✔️	✔️
Minimum granularity	Instance	Database	Instance
Backup set download	✔️	✔️	✔️
Backup set query	❌	❌	❌
Restoration in minutes	✔️	❌	✔️
Data Disaster Recovery sandbox	✔️	❌	✔️

NoSQL databases

Logical backup

Operation	MongoDB	Redis
Database types	Alibaba Cloud databases; self-managed on ECS; on-premises; third-party cloud	Alibaba Cloud databases; self-managed on ECS; on-premises; third-party cloud
Data source type	MongoDB	Redis
Supported versions	4.2, 4.0, 3.6, 3.4, 3.2	4.0 (standard master-replica architecture only)
Full data backup	✔️	✔️
Incremental log backup	✔️ (replica set architecture only)	✔️
Real-time backup	RPO in 10 minutes	RPO in 10 minutes
Instance restoration	✔️	✔️
Minimum granularity	Collection	Database
Backup set download	✔️	❌
Backup set query	❌	❌

Redis 5.0 or later is not supported. Redis cluster instances are not supported. Only the standard master-replica architecture is supported.

Database objects supported by logical backup

Important

If the data source contains Chinese table names or field names, data recovery fails. Join the DingTalk group (ID: 35585947) to report the issue or submit a ticketsubmit a ticket.

Database engine	Supported objects
MySQL, MariaDB	Table, index, view, trigger, constraint, primary key, foreign key, stored procedure, function
PostgreSQL, PolarDB for PostgreSQL	Table, index, view, function, stored procedure, constraint, foreign key, sequence, rule, domain, extension, operator
PolarDB for MySQL, PolarDB for PostgreSQL (Compatible with Oracle), PolarDB-X	Table, index, view, trigger, stored procedure, role, constraint, user-defined function, user-defined table type
SQL Server	Table, index, view, trigger, stored procedure, user, role, constraint, user-defined function, user-defined data type, user-defined table type
Oracle	Table, index, view, constraint, foreign key, sequence, trigger, function, stored procedure, synonym, package
Redis	STRING, BINARY, LIST, SET, SORTED SET, HASH, BITARRAY, HYPERLOG, GEO, MODULE
MongoDB	Table, collection, index, view, function, user, role ( Note Admin databases in MongoDB cannot be backed up.)