Re: SqlExpress Merge Agent slow Profiles & one way Rep

Tech-Archive recommends: Fix windows errors by optimizing your registry

The profiles are kept on the publisher. The slow agent profile is ideal for low bandwitdth links between your publisher and tthe subscriber.

SQL Express does not have an msdb database which your code is looking for on the subscriber. This is why it won't work.

"Gatecrasher" <Gatecrasher@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1EF0C287-68F3-4213-B32A-834150566D65@xxxxxxxxxxxxxxxx
I want to make this SQLExpress clients Agent use the "Slow connection"
profile. Setting slow profile on the server I assume does nothing for me at
all??? I assume that because the Agent runs on the client. Correct?

So does a SQLExpress install have "agent profiles" given it doesn't have a
real Agent at all?

i thought I would try something obvious

AgentProfile profile = new AgentProfile();
profile.Name = "My Profile";
profile.AgentType = AgentType.MergeAgents;
profile.ConnectionContext = conn;
profile.Create();
MergeSynchronizationAgent agent = subscription.SynchronizationAgent;
profile.AddParameter("-DownloadGenerationsPerBatch", "1");
agent.ProfileName = "My Profile";

but this fails because the profile.Create() dies with

_innerException = {"Invalid object name 'msdb..MSagent_profiles'."}

Required table missing

Am i just missing the point here that SQLExpress does not allow you to set
values on the Agent?? If that is the case how can I change my batch size for
slow connections?

If I google this

MergeSynchronizationAgent.DownloadGenerationsPerBatch

I get a new property for SQL 2008 but it only shows up for MSDN in the
German site!!

I installed SqlExpress 2008 and after a bit of messing around, the
SqlServer.Replication.DLL is not in the GAC when it used to be, this new
Property exists.

I wonder if it will find its way back into 2005, without it I am stumped.
Also discovered cannot Merge Replicate from 2005 Publisher to 2008
Subscriber, not allowed.

Any ideas?

.

Relevant Pages

  • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
    ... I do not need to wait until off-hours to run a trace on the subscriber. ... Specifies whether the agent attempts to poll replicated transactions ... profile for distributor agents has as profile parameters one called ... I cannot find a way to explain why Distributor Agents are to ...
    (microsoft.public.sqlserver.replication)
  • Re: changing merge agent profile for HTTPS - mergeSubscriberType = anonymous
    ... Looking for a SQL Server replication book? ... 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 - ... get the agent at the publisher/distributer use a slower profile - I've ...
    (microsoft.public.sqlserver.replication)
  • Re: changing merge agent profile for HTTPS - mergeSubscriberType = anonymous
    ... 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 - ... Looking for a SQL Server replication book? ... get the agent at the publisher/distributer use a slower profile - I've ...
    (microsoft.public.sqlserver.replication)
  • Re: SqlExpress Merge Agent slow Profiles & one way Rep
    ... if the profiles are kept on the publisher why does my code not work? ... saying the msdb table is missing on SQL Express (the subscriber) but if the ... Surely the profiles exist where the Agent runs, which for a Merge agent is ... Are you saying that my Agent on the subscriber gets it's profile from the ...
    (microsoft.public.sqlserver.replication)
  • Re: SqlExpress Merge Agent slow Profiles & one way Rep
    ... What I am saying is that the profiles on defined on the publisher will be used, by default the default profile, but on your client in code you can say - use the slow link profile. ... A subscriber would use the default profile on Pub2, unless you told the subscriber to use a different profile on Pub2. ... > Surely the profiles exist where the Agent runs, which for a Merge agent> is ...
    (microsoft.public.sqlserver.replication)