Monday, March 19, 2012

merge replication one way

I saw a brief sample of a switch you can add to the merge
replication so the replication only goes one way...I know
you have to use push scription to do it...the switch is
ExchangeType='value'...can i add this within the gui
interface or am I going to have to add it commandline?Hi Jamie,
Thanks for Vyas' help. I agree with him. Also, I'm including some
supplemental information below:
-ExchangeType [1|2|3]
It specifies the type of exchange. A value of 1 indicates that the agent
should upload data changes from the Subscriber to the Publisher. A value of
2 indicates that the agent should download data changes from the Publisher
to the Subscriber. A value of 3, the default, indicates that the agent
should first upload data changes from the Subscriber to the Publisher and
then download data changes from the Publisher to the Subscriber.
For additional information regarding this issue, please refer to the
following information on SQL Server Books Online.
Topic: "Replication Merge Agent Utility"
Thanks for using MSDN newsgroup.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment