All Products
Search

This Product

    Data Management:Overview of data synchronization solutions

    Document Center

    Data Management:Overview of data synchronization solutions

    Last Updated:Mar 28, 2026

    Data Transmission Service (DTS) keeps data in sync between databases in real time. Use it to replicate data across regions, feed analytics pipelines, or build resilient multi-site architectures.

    Use cases

    • Active geo-redundancy: Run active database nodes in multiple regions so users always connect to the nearest one, reducing latency and improving availability.

    • Geo-disaster recovery: Maintain a live replica in a separate geographic region so you can fail over quickly if the primary region goes down.

    • Zone-disaster recovery: Keep a synchronized replica in a different availability zone within the same region to protect against zone-level failures.

    • Cross-border data synchronization: Replicate data across country boundaries to meet data residency requirements or serve international users from local databases.

    • Cloud business intelligence (BI): Stream production data to a dedicated analytics database so BI queries don't affect transactional workloads.

    • Real-time data warehousing: Feed a data warehouse with live changes from operational databases, keeping reports and dashboards current.

    Billing

    DTS charges for the data synchronization feature. For pricing details, see Billing methods.

    Synchronization types

    TypeWhat it does
    Schema synchronizationCopies the schemas of selected objects — tables, views, triggers, and stored procedures — from the source database to the destination database. Run this first if the destination database does not already have matching schemas.
    Full data synchronizationCopies all existing (historical) data from the source to the destination. This establishes the baseline that incremental synchronization builds on. Select both Schema Synchronization and Full Data Synchronization when you configure a task to simplify setup.
    Incremental data synchronizationEnabled by default. DTS synchronizes incremental data generated in the source database to the destination database in real time.

    Before configuring a task, check whether schema synchronization is supported for your source database type. If it is not supported, create the destination database schema manually before starting the task.

    Synchronization topologies

    For the full list of supported topologies, see Synchronization topologies.

    Supported source databases

    Select a source database type to view supported database versions, synchronization types, and configuration steps.