Using the rs_address Datatype

The rs_address special datatype makes a unique subscription resolution technique possible: bitmaps of the rs_address datatype (based on the underlying int datatype) are compared with a bitmask in a subscription’s where clause to determine whether a row should be replicated.

Prerequisites
You must include any columns that use the rs_address datatype in the searchable columns clause of the replication definition in order to perform bitmap comparison using the where clause.
Task

  1. To use this subscription resolution method, create tables that use columns of the int datatype.
  2. Create a replication definition that includes these columns in the column list, but declare the datatype as rs_address instead of int.
Related concepts
Bitmap Subscriptions