Help Center> Data Replication Service> User Guide (Paris Region) > FAQs> Product Consulting> What Are the Differences Between Real-Time Migration and Real-Time Synchronization?
Updated on 2023-01-05 GMT+08:00

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

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.

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.

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.