A partial-update transaction allows you to directly insert a character string or overwrite an existing character string of a table column without issuing a delete and replace commands.
Replication Server 15.1 supports replication of partial-update transaction to supported LOB datatypes.
To implement partial update, use the new rs_updatetext LTL command:
{distribute|_ds} command_tags {applied|_ap} 'table'.rs_updatetext
{partialupd|_pu} [{first|_fi}] [last] [{changed|_ch}] [with log]
[{withouttp|_wo}] [{offset|_os}=offset {deletelen|_dln}=deletelength]
[{textlen|_tl}=length] text_image_column
Partial update:
Does not support multiple character set conversion.
Support is restricted to Microsoft SQL Server 2005.
For more information about partial update, see the Replication Server Design Guide.
