RMO: Replication between SQL Server 2005 amd SQL Server 2005 Express

RMO: Replication between SQL Server 2005 amd SQL Server 2005 Express

• JerryP

  Hi Mahesh!
  
  You helped me!
  
  I forgot to reference the Microsoft.SqlServer.Replication.dll assembly. Because the class MergeSynchronizationAgent is in this assembly, my code couldn't work.
  
  

• GKOver

  We still not found a way to get the end of the merge...

  Can you please help us

  
  

• NeoSchu

  Can you register the dlls and see if that helps

  And at what point is it giving you this error. Compile time or run time

  
  
  

• DM_01

  In addition to Microsoft.SqlServer.RMO.dll, you will need to reference Microsoft.SqlServer.Replication.dll. The MergeSynchronizationAgent is in this dll. Try that see if it helps. Let me know if that doesnt solve your problem. We can trouble shoot more.
  
  

• Qaser

  We are trying to go around this problem, with horrible solution...

  If you are still alive, your help is welcome

  
  

• Jesse McGatha

  Hi Mahesh,

  I have been trying to use RMO to replicate SQL Express with SQL 2005 Server. I am able to create the Subcription and Register the Subscription in the Server. But I am not able to find out the MergeSynchronizationAgent object. I have already reference the Microsoft.SqlServer.Replication (Microsoft.SqlServer.Rmo.dll) but still I dont see the object. Can u help me please.

  Thanks

  Patrick Babu

  
  
  

• Matt Attaway

  I had a similar problem, When you add a reference through Visual Studio and under the .NET tab select "Microsoft.SqlServer.Replication" it is actually adding the RMO assembly. The only way I found to get a hold on the MergeSynchronizationAgent object is to browse to "C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies" and add a reference to "Microsoft.SqlServer.Replication.dll" manually.

  Hope this helps you out.

  
  

• matrushka

  Wouldnt this work
  
  MergePullSubscription mergepubllsub = new MergePullSubscription("subdb",
                          pubserver, "pubdb", "publication", subconn)
  mergepubllsub.Create();
  MergeSynchronizationAgent syncAgent = mergepubllsub.SynchronizationAgent
  syncAgent.Synchronize();
  
  
  
  

• matthew.devalle

  Thank you for your tips.
  
  But the problem is, that the MergePullSubscription class doesn't have a property SynchronizationAgent... (I use version 9.0.242.0 of Microsoft.SqlServer.Rmo.dll). Is there any newer version or does this property no longer exist
  
  
  
  

• Daniel Glastonbury

  Hi,

  We have exactly a similar problem, but our reference are okay...

  (MergeSynchronizationAgent throw an "Class not registered" exception)

  Have you any idea

  
  

• adedes

  Thanks for your reply.

  This is a run time error on the MergeSynchronizationAgent obtained with the SynchronizationAgent property.

  As it is not a compile time error, I think the dlls are already registred. If not, what is the register process

  We also try to use the asynchronous method SynchronizeWithJob but we are waiting for the 'status'... But it is never refreshed...

  
  

• SqlBoi

  SynchronizeWithJob(), I think this is equivalent to executing sp_start_job to start the merge agent job. But since express has neither agent nor jobs, this will not work in the express case.
  
  Instead try using SynchronizationAgent.Synchronize().
  
  BOL should have more information and example. If not, the newest BOL should have proper information.
  
  
  
• RMO: Replication between SQL Server 2005 amd SQL Server 2005 Express