Replication Agent for Microsoft SQL Server 15.7.1 SP120 now supports replication of varchar(max), nvarchar(max), and varbinary(max) large object (LOB) datatypes into an SAP HANA® replicate database.
In earlier versions, varchar(max), nvarchar(max), and varbinary(max) LOB datatypes were considered as a partial update, even for a full LOB update. Replication of partial updates to LOB datatypes was supported only in the Microsoft SQL Server to Microsoft SQL Server (homogeneous) replication environment.
With Replication Agent for Microsoft SQL Server 15.7.1 SP120, you can use the lr_partial_updates_allowed configuration parameter to determine whether replicate databases support partial updates to LOB datatypes.
By default, lr_partial_updates_allowed is true.
When the lr_partial_updates_allowed is true, Replication Agent sends changes to LOB datatype columns as partial updates to Replication Server. Replication Server sends partial updates to the replicate databases that have native support for partial LOB updates, such as Microsoft SQL Server.
If the replicate database do not support partial updates to LOB datatypes, set the lr_partial_updates_allowed to false.
When the lr_partial_updates_allowed is false, Replication Agent converts partial LOB updates to a full update, which is consumed in heterogeneous replication environments. If partial LOB updates are detected, an error exception occurs.
To replicate LOB datatypes from the Microsoft SQL Server to SAP HANA replicate database, set the lr_partial_updates_allowed parameter to false.
For Microsoft SQL Server LOB datatype mappings and limitations, see the Replication Server Administration Guide: Volume1.