Friday, April 17, 2009

Procedure to enable the selective replication between 2 servers hosting the ITS database.

Suppose for example we have 2 servers Server1 and Server2 and ITS database on each server have chat room names prefixed with sr1 and sr2 respectively like sr1: Place1, sr1: Place2, sr2: Place1 and sr2: Place2...etc. Now the goal is that when both databases gets replicated then we shouls not see the room prefixed with sr1 on Server2 and vice versa. The selective replication formula for Server1 will be SELECT !(@Begins(txtChatPlaceDisplayName; "sr2"))

The selective replication formula for Server2 will be SELECT !(@Begins(txtChatPlaceDisplayName; "sr1"))

No comments: