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.

To use this subscription resolution method:

  1. 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.

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.

See “Bitmap subscriptions” for more information on using rs_address columns for bitmap subscription resolution.