I am interested in using Policies to deploy local replicas to our field sales teams. I have tested this functionality and it works great! However, I am unable to determine if I can change the replication formula for a user. More specifically, I want to change the replication formula and let the policy force this formula change to a local replica that already exists.
I tried this (by changing the replication formula on the db on the server - when replicating with user), but the policy did not force the replication formula change. The only way I could get this to work was to have the user to delete the local replica so that the policy would create a new replica with the formula change.
Desktop policies have nothing to do with replication formulas. The reason that the local replica’s replciation formula didn’t change when you updated the one on the server is because of this property on the local replica:
With or without policies, if that property were set on the server replica when the client initially pulled down their local replica, then IIRC, the property would also be set on newly-created replicas of the db, and formula changes would then be synced. And if it were set on a local replica after replica creation, then again, the formula would be synced.
Thank you for your response. I had the replication formula option selected on the properties. The solution was that I needed replication to initiate the replication change. The policy actually created the replica initially without replication - this was the cause of confusion!