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

Homogeneous databases are migrated as a whole. Tables, data, indexes, views, stored procedures, functions, database accounts, and database parameters can be migrated at the table level, database level, or all dimensions.

Maintains continuous data flow between different services, synchronizes tables and data, and meets various flexibility requirements. Objects can be migrated at the table level or database level. Data synchronization between heterogeneous databases is supported.

The remote primary/standby switchover can be achieved. Instance-level disaster recovery is supported. Object selection is not supported.

Supported databases

For details, see Migration Overview.

For details, see Synchronization Overview.

For details, see DR Overview.

Functions and features

• Users can be migrated.
• Parameters can be compared.

• Synchronization objects can be edited in the incremental phase, and added or deleted dynamically.
• 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.
• Data processing is supported. You can add rules, such as data filtering and column processing, for selected objects.

• Instance-level DR
• Parameter comparison
• Primary/Standby switchover

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.