How to replicate more than 256 articles in Merge Replication?

In merge replication there is a limitation in the maximum number of articles that you can publish, which is 256. However, this limitation is 32,767 articles for snapshot and transactional replication.  This is a very small number of articles for large systems, however the following workaround can be used to publish additional articles.

1. Create several publications so that one publication does not contain more than 256 articles. However, if you have several publications it may lead to a reduction in performance.
OR
2.
a. Generate a script for your publication and save the script file
b. Now delete the all articles for the publication
c. Run the snapshot agent, it will run successfully without any errors
d. Run these sp_addmergearticle procs by setting the @dynamic_filters to False
e. Execute the script
f. Run the snapshot agent again




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |