Moving records during replication

I keep reading in various places of the replication documentation that records can be _moved_ as opposed to just being copied. How can I do this? I can't seem to find anywhere during setting up the publication, articles or subscription an option that allows me to do that!

Thanks,

Val

The "moved" behavior you heard of is probably because the row is being "copied" to a new location, and then deleted from the old location. A feature in merge replication that might cause this behavior is partition groups with the partition option setting to allow rows being changed out of the current partition.

Here is an example:

You setup the partition group with the filter that each subscriber will download all rows with ID column, so that user1 get all rows with ID="user1" and user2 get all rows with ID="user2". If user1 update the ID column in a row in the subscriber and make it ID="user2", this row will now fall out of the current partition, so it will be deleted in user1's subscription, and it will be downloaded to user2's subscription. Now you get the hehavior that this row is moved from user1 subscriber to user2 subscriber.