none
Add article

    Question

  • Can we add an article to the existing publication without generating a snapshot with all articles?
    Tuesday, May 7, 2019 8:07 PM

Answers

All replies

  • If you are not using immediate_sync (and allow_anonymous is set to false), yet you can. But do not do this using the wizard. use script to add the article and then run sp_refreshsubscriptions.
    Tuesday, May 7, 2019 8:36 PM
    Moderator
  • Hi SK Varma,
    Could you please try to follow the steps from below document to add article? Please refer to Adding a new articles to an existing transactional replication without snapshot of entire articles.
    Hope this could help you.
    Best regards,
    Cathy Ji

    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

    • Marked as answer by SK Varma Wednesday, May 8, 2019 7:30 PM
    Wednesday, May 8, 2019 5:30 AM