Snapshot Replication and Merge Replication

Cindy See 141 Reputation points
2023-01-10T05:57:56.733+00:00

Do we have to publish the article every time if there is changes to the article or we just need to publish it once and the system will automatically replicate the changes in snapshot replication?

Is there any way that we can stop or disallow subscriber from updating data into the publisher in a merge replication?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,857 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,571 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
368 questions
No comments
{count} votes

Accepted answer
  1. Seeya Xi-MSFT 12,746 Reputation points Microsoft Employee
    2023-01-10T08:35:12.297+00:00

    Hi @Cindy See ,

    > Do we have to publish the article every time if there is changes to the article or we just need to publish it once and the system will automatically replicate the changes in snapshot replication? You do not need to publish the article every time. After a publication has been created, most publication and article properties can be changed, but some require that the snapshot be regenerated and/or subscriptions be reinitialized. Please refer this MS document: Change Publication and Article Properties. > Is there any way that we can stop or disallow subscriber from updating data into the publisher in a merge replication? Isn't the syncing of subscribers to publishers a feature of merged replication? If you have the option, you can choose another replication. I found this post. It mentions that you can add a row filter. Like this WHERE HOST_NAME() ! = 'Server A' But I don't have the environment to reproduce this method now. The best advice is still that you can deploy another replication.

    Best regards, Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    No comments

0 additional answers

Sort by: Most helpful