Heterogeneous Multi-Path Replication

Use multiple replication paths to increase replication throughput and performance, and reduce contention.

In a single-path replication environment, transactions replicate serially from the primary database to the replicate database to ensure the primary database transaction commit order, and therefore to ensure that the replicate database is consistent with the primary database. The serial mode of applying transactions to the replicate database remains, even though multiple applications typically execute their respective transactions in parallel at the primary database, or even if there are transactions arriving from multiple primary databases.

There are replication environments that can maintain data consistency within a subset of tables, without serializing all transactions that originate from the same primary database. A typical example of this environment is when different applications that access different sets of data modify a single primary database. The different sets of data within the subset of tables that are modified by a specific application continue to replicate serially. Data in different subsets of tables can replicate in parallel.

Multi-Path Replication™ supports the replication of data through different streams, while still maintaining data consistency within a path, but not adhering to the commit order across different paths.

A replication path encompasses all the components and modules between the Replication Server and the primary or replicate database. In multipath replication, you can create multiple primary replication paths for multiple Replication Agent connections from a primary database to one or more Replication Servers, and multiple replicate paths from one or more Replication Servers to the replicate database. You can configure multi-path replication in warm standby and multisite availability (MSA) environments. You can convey transactions over dedicated routes between Replication Servers to avoid congestion on shared routes, and you can dedicate an end-to-end replication path from the primary database through Replication Servers to the replicate database, to objects such as tables and stored procedures.

See Replication Server > Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication to configure Adaptive Server as the primary or replicate database in a multipath replication system.


Multi-Path Replication is licensed as part of the Advanced Services Option. See Replication Server Installation Guide > Planning Your Installation > Obtaining a License.

System Requirements

Primary and Replicate Database Pairs Supported in Heterogeneous Multi-Path Replication Systems
Primary Database Replicate Database
Adaptive Server Sybase IQ
Oracle Sybase IQ
Adaptive Server Oracle
Oracle Adaptive Server
Oracle Oracle
Multi-Path Replication Database Versions Supported
Database Supported Versions
Adaptive Server 15.7 and later
Oracle Oracle 10g and 11g. See Replication Server Options > Replication Agent Release Bulletin > Product Summary > Product Compatibility.
Sybase IQ 15.1 and later. See Replication Server Release Bulletin > Product Compatibility > Replication Server Interoperability .