SAP Replication Server Support for Compressed Data

SAP Replication Server decompresses compressed SAP ASE data before sending it to the replicate database.

Support for replication of compressed data between an SAP ASE primary database and an SAP ASE or heterogeneous replicate database depends on whether the data is in-row or off-row:

Replication Server supports replicating in-row non-LOB compressed data between databases.
SAP Replication Server supports replicating compressed off-row LOB columns between an SAP ASE primary database and an SAP ASE or heterogeneous replicate database. SAP Replication Server decompresses LOB data before sending it to a heterogeneous replicate database. SAP Replication Server sends compressed LOB data directly to an SAP ASE replicate database only if the replicate has the same LOB schema, character set, endianness, version, and page size as the primary SAP ASE database. Otherwise, SAP Replication Server decompresses LOB data before sending it to the replicate SAP ASE database.

The Replication Server dsi_do_decompression parameter must be on for SAP Replication Server to decompress LOB data. This parameter is set to on in connection profiles for connecting to a heterogeneous replicate database.

For the LOB data decompression feature, the primary and replicate SAP Replication Servers and the primary SAP ASE must be version 15.7.1 SP100 or later.

Only SAP ASE 15.7 ESD #1 and later and Replication Server 15.7.1 and later support compressed large object (LOB) column replication. All intermediate SAP Replication Servers in the route from SAP ASE must also be version 15.7.1 and later.