nav-img
Advanced

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

Item

Real-Time Migration

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

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.

Supported databases

For details, see Migration Overview.

For details, see Synchronization Overview.

Functions and features

Users can be migrated.

Users cannot be migrated.

Parameters can be compared.

Parameters cannot 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.

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.

Data processing is not supported.

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

Primary/Standby switchover is not supported.

Primary/Standby switchover is not 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.