Saturday, February 25, 2012

Data Validation on merge agent

Hi,
I intend to set up data validation and re-initialize on merge agent. But
I'm not sure if it will cause data lost at subscriber side.
If the data validation fail, the merge agent is supposed to re-initialize
the subscriber from last successful data validation. Does it mean any data
change at the subscriber after the specific re-initialization point would
lost?
Please Help
Thanks
Yong
There is an option to upload the subscriber changes before the subscription
is reinitialized. If you use this option you will not lose any subscriber
data.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"yong" <yong@.discussions.microsoft.com> wrote in message
news:8E312D5B-5A2D-494B-A6BE-62E056993DDB@.microsoft.com...
> Hi,
> I intend to set up data validation and re-initialize on merge agent. But
> I'm not sure if it will cause data lost at subscriber side.
> If the data validation fail, the merge agent is supposed to
> re-initialize
> the subscriber from last successful data validation. Does it mean any data
> change at the subscriber after the specific re-initialization point would
> lost?
> Please Help
> Thanks
> Yong
>

No comments:

Post a Comment