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

Instead try using SynchronizationAgent.Synchronize().

BOL should have more information and example. If not, the newest BOL should have proper information.

MaheshDudgikar at 2007-9-9 >

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

MaheshDudgikar at 2007-9-9 >

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

SagayaBabu at 2007-9-9 >

Hi,

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

(MergeSynchronizationAgent throw an "Class not registered" exception)

Have you any idea ?

e-deal at 2007-9-9 >

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

e-deal at 2007-9-9 >

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

If you are still alive, your help is welcome

e-deal at 2007-9-9 >