How to merge only to publisher?
-
Hi,
I'm using SQL2005 and have implemented a merge replication; I need to merge subscribers' data to publisher for some of my articles but don't want my subscribers have publisher's data. How may I do that? I don't want to use filters.
Any idea is appreciated
-
Just use a separate DB on the publisher to collect the merged data.
Cheers,
* Noel -
How to....... configure one-way merge replication? Add -ExchangeType to the merge agent's job step parameters. The values are listed in BOL under the programming topic 'EXCHANGE_TYPE constant', but basically there are three options: 3=bidirectional, 2=Publishers->subscribers only and 1=Subscribers->Publishers only. Bidirectional is the default. It might seem possible to create a new profile and add the new parameter (-ExchangeType in this case) to MSagent_parameters for the relevant profile_id (MSagent_profiles). Unfortunately, the parameters picked up from the profile are hardcoded in sp_MSvalidate_agent_parameter so not all the ones listed on the MS site are acceptable. To try to add a particular parameter, use sp_add_agent_parameter - it'll return an error if it is not acceptable, in which case you must resort to the command-line arguments..
http://www.replicationanswers.com/Merge.asp
MohammedU
Microsoft SQL Server MVP -
Thank you Mohammad for you reply
, though I'm still having problem with it; I've created a new profile and set the -ExchangeType to 1 but it's been one way from publisher to subscriber! By the way, I need my publisher keep it's own data as well; is that possible by one way merge replication?
-
You suppose to add it in merge agent job not in profile... if I am not mistaken...
Did you change the configuration in merge agent job?
MohammedU
Microsoft SQL Server MVP
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply