none
can merge replication target a db already targeted by transaction replication RRS feed

  • Question

  • Hi we run 2017 standard. We are absent pk's on some of our tables that we want replicated to the same db where we already tran replicate many tables that do have pk's.  

    can merge replication target a db already targeted by transaction replication?

    Wednesday, August 21, 2019 4:58 PM

Answers

  • Hi db043190,

     

    >>can merge replication target a db already targeted by transaction replication?

     

    Based on my experience, it is impossible to use merge and transcational replication on same server with same database.

    If you want to apply transactional and merge replication so you can use different database name with different article. I suggest you copy the entire database directly with log shipping.

     

    Best regards,

    Dedmon Dai


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Thursday, August 22, 2019 7:25 AM