lr_partial_updates_allowed

(Microsoft SQL Server only) Converts partial updates to varchar(max), nvarchar(max), and varbinary(max) large object (LOB) datatypes at the primary database to a full update. Sends partial updates to LOB data to databases that have native support.

Default

true

Values

true – 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.

false – 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.

Comment

  • To replicate LOB datatypes from the Microsoft SQL Server to SAP HANA® replicate database, set the lr_partial_updates_allowed parameter to false.

  • If the replicate database do not support partial updates to LOB datatypes, set the lr_partial_updates_allowed to false.

Note: Adaptive Server and Microsoft SQL Server replicate databases only support replication of partial LOB updates.