Post reply

Merge Replication synchronization in Stored procedure

  • October 24, 2014 at 3:40 pm

    #397561

    I'm updating some tables in a subscriber database with a stored procedure. After the tables get updated I'd like to sync them with the other subscriber dbs and the publisher db in that same stored procedure.

    I can do it manually in SSMS with the View Synchronization method. Are my only alternatives a batch job or C#?

    Thanks.

  • October 25, 2014 at 3:18 pm

    #1754785

    You have options.

    When using Standard Edition or higher, when a Merge subscription is created, an associated Merge Agent job is created. You start the job to synchronize the subscription.

    You can invoke the Merge Agent executable, replmerg.exe, and pass the appropriate parameters to synchronize the subscription.

    RMO via C# or VB.NET is an option in 2012 or earlier but it has been deprecated and I believe it has been removed in 2014.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply