Groups | Blog | Home
all groups > sql server replication > august 2006 >

sql server replication : changing merge agent profile for HTTPS - mergeSubscriberType = anonymous


Hilary Cotter
8/9/2006 10:48:35 PM
use the profileName property of the MergeSynchronizationAgent class.

--
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



[quoted text, click to view]

Bruce Baker
8/10/2006 12:00:00 AM
Thanks very much Hilary

Just to confirm, for dim old me, if I want to change the profile for one
subscriber, I need to change it at the subscriber in my RMO code -

agent.ProfileName = "Slow link agent profile."
agent.Synchronize()

If I want to change it for all publications for all subscriptions and their
subscribers, I can change the default at the distributer...


Is this right ?

Thanks
Bruce




[quoted text, click to view]

Bruce Baker
8/10/2006 12:00:00 AM
Hi


We are using HTTPS merge replication - subscriber is nosync

Our setup is as follows:

subscription.CreateSyncAgentByDefault = False -- I wrote a windows service
to synchronise
subscription.UseWebSynchronization = True
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous

Some of our subscribers have low-quality internet connections - how do I get
the agent at the publisher/distributer use a slower profile - I've read How
to: Work with Replication Agent Profiles (Replication Transact-SQL
Programming)
but can't see where you specifiy an alternate agent profile

On the distributer / publisher (same machine) I go to replication monitor ->
Warnings and Agents - I can only set the profile for the snapshot agent....

thanks
Bruce

Hilary Cotter
8/11/2006 11:39:00 AM
You are correct about setting it on a per subscription basis. However it is
difficult to change the default profile for a publication.

--
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



[quoted text, click to view]

AddThis Social Bookmark Button