Heterogeneous Multi-Path Replication

Replication Server 15.7.1 extends supports for Multi-Path Replication to replication systems with heterogeneous databases.

As of Replication Server 15.7, you can distribute transactions over multiple replication paths from a primary Adaptive Server database to Replication Server, through dedicated routes between Replication Servers and over multiple connections to a replicate Adaptive Server database. See Replication Server > Administration Guide Volume 2 > Performance Tuning > Multi-Path Replication.

In version 15.7.1, you can build multiple replication paths and dedicated routes between databases such as Adaptive Server and Sybase IQ, and Adaptive Server and Oracle.

See Replication Server Heterogeneous Replication Guide > Sybase IQ as Replicate Data Server > Multi-Path Replication to Sybase IQ to configue multipath replication to Sybase IQ databases. See Replication Server Heterogeneous Replication Guide > Heterogeneous Multi-Path Replication for heterogeneous multipath replication scenarios.

Supported Heterogeneous Database Multipath Replication Systems

Primary and Replicate Database Pairs Supported in Heterogeneous Multipath Replication Systems
Primary Database Replicate Database
Adaptive Server Sybase IQ
Oracle Sybase IQ
Adaptive Server Oracle
Oracle Adaptive Server
Oracle Oracle
Note: Replication from an Oracle primary database requires the Replication Agent for Oracle which is included in Replication Server Options.
Database Versions Supported for Multipath Replication
Database Supported Versions
Adaptive Server 15.7 and later
Oracle

Oracle 10g and 11g. See Replication Server Options > Replication Server Options Release Bulletin > Product Summary > Product Compatibility.

Sybase IQ 15.1 and later. See Replication Server Release Bulletin > Product Compatibility > Replication Server Interoperability .

License

Multi-Path Replication is licensed as part of the Advanced Services Option. Replication to Sybase IQ using RTL is available in the Real-Time Loading Edition (RTLE). See Replication Server Installation Guide > Planning Your Installation > Obtaining a License.

Replication from Oracle requires Replication Agent for Oracle. See Replication Server Options > Replication Agent Installation Guide > Planning Your Installation > Licensing.