What Are the Differences Between Real-Time Migration, Real-Time DR, and Real-Time Synchronization?

Scenario

Migration can be performed between different cloud platforms, from on-premises databases to cloud databases, or on cloud databases across regions.

Real-time analysis, report system, and data warehouse environment

You can perform disaster recovery between on-premises databases and cloud databases, or between databases across cloud platforms.

Characteristics

1. Homogeneous databases are migrated as a whole.
2. Tables, data, indexes, views, stored procedures, functions, database accounts, and database parameters can be migrated.
3. You can choose to migrate all objects, tables, or databases based on your service requirements.

1. Homogeneous and heterogeneous databases are synchronized to maintain continuous data flow between different applications.
2. Tables and data can be synchronized to meet various flexibility requirements.
3. Objects can be synchronized at the table level or database level.

1. Data disaster recovery between homogeneous databases can be performed.
2. The remote primary/standby switchover can be achieved.
3. Instance-level disaster recovery is supported. You cannot select databases or tables as objects.

Supported databases

For details, see Migration Overview.

For details, see Synchronization Overview.

For details, see DR Overview.

Functions and features

Users can be migrated.

Users cannot be migrated.

By default, all users are migrated. You cannot select the users to be migrated.

Parameters can be compared.

Parameters cannot be compared.

Parameters can be compared.

Migration objects cannot be edited in the incremental phase.

Synchronization objects can be edited in the incremental phase, and added or deleted dynamically.

Disaster recovery objects cannot be edited in the incremental phase.

Object name mapping is not supported.

Object names mapped to the destination database can be changed, so the names of tables and databases in the source and destination databases can be different.

Object name mapping is not supported.

Data processing is not supported.

Data processing is supported. You can add rules, such as data filtering and column processing, for selected objects.

Data processing is not supported.

Primary/Standby switchover is not supported.

Primary/Standby switchover is not supported.

Primary/Standby switchover is supported.

Billing

Only pay-per-use billing is supported.

Both pay-per-use and yearly/monthly billing modes are supported.

Both pay-per-use and yearly/monthly billing modes are supported.

Remarks

Different data flows support different functions and features. For details, see Precautions.

Different data flows support different functions and features. For details, see Precautions.

Different data flows support different functions and features. For details, see Precautions.