Results 1 to 2 of 2
  1. #1
    Join Date
    May 2008
    Posts
    1

    Unanswered: Single direction transfer of data in merged publication (subscriber to publisher)

    Hi,
    We have an existing merged replication schema that works well. One of the
    tables is named audit. Currently this is a bidirectional transfer. However,
    we want a new audit table that will transfer data from the subscriber to the
    publisher and not the other way round. I have a script that was generated as a backup script when replication was first created. I have no idea which parameter to change in order to have the merge replication going from subscriber to publisher. Any advise is helpful. Thanks.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Remove audit table from merge replication, create a transactional publication with your current merge subscriber to be a publisher, and configure your current merge publisher to be your transactional replication subscriber.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •