February 21, 2003 at 10:27 am
I understand replication is 2 way by default, but that you can set it to just 1 way by adding the ExchangeType parameter of 1 to replmerg.exe (the merge agent). I have been asked to set this up, but don't understand how you pass this parameter (or any parameter), for I can't find where it is set. I have created a merge job through the Wizard (SQL2k, sp3) and looked at all the settings for this and at the associated jobs that were created but couldn't find anywhere in which to add the command paramater.
Is the only way to do this to create a job manually which runs replmerge.exe from the command line? It is not making sense to me at all at the moment.
--the etxt below comes from MS.
However, remember that the merge agent is only an executable file (Replmerg.exe). The merge job in SQL Server Agent simply calls this executable and passes command-line arguments to it. One of those optional command-line arguments is ExchangeType, which has three possible values: 1 specifies push, 2 specifies pull, and 3 specifies two-way (this is the default). If you set up merge replication with a push subscription and also set the ExchangeType to 1, then SQL Server will push data from the publisher to the subscriber, and not send data back from the subscriber to the publisher.
February 24, 2003 at 8:00 am
This was removed by the editor as SPAM
February 24, 2003 at 9:58 am
Have not tried - it's not possible to just modify the existing merge job?
Andy
February 24, 2003 at 10:08 am
actually, I did manage to sort it, I think,, after the replication wizard has run, you can modify the job and add the extra exchange type parameter at the end this seems to work fine. E.g.
-Publisher [HOBBS2] -PublisherDB [standbye_db] -Publication [standbye_db] -Subscriber [HOBBS2\FIRTH2] -SubscriberDB [Standby_db] -Distributor [HOBBS2] -DistributorSecurityMode 1 -ExchangeType 1
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply