I would like to know if that feature is supported in SQL Server 2k5 (or 2k8) and if not how would you implement it.
I'm trying to figure out if it's possible to have a central server (let's name it A) which replicate with subscribers servers B and C using merge replication. (B and C does not need to communicate together)
Data on server A need to be unencrypted while these same data need to be encrypted on server B and C.
Is there a way to tell the merge agent to encrypt those data before sending on server B and C and decrypt those data that come back?
Thank you