Questions tagged [merge-replication]

A type of replication in SQL Server in which Publishers and Subscribers can work autonomously and later reconnect, synchronize, and merge data changes to achieve convergence among all nodes in the topology. Merge replication is typically used in server-to-client environments.

Filter by
Sorted by
Tagged with
1
vote
1answer
710 views

SQL Server Merge Replication, Agent Batch Size

Is there anyway to increase the merge agent batch size after the publication is created? I know DownloadGenerationsPerBatch flag when creating a new Publication, however what I'm looking for is a way ...
3
votes
1answer
492 views

Why Regenerate Snapshots For Merge Replication

I am in the process of implementing merge replication in SQL 2012 with web sync. I am wondering two things, Why is it suggested to regenerate the snapshots every 14 days by default? With web sync ...
1
vote
1answer
1k views

Merge replication - can't create snapshot – timeout

I have a SQL Server 2008 database, and I need a merge replication because I want to sync with mobile devices afterwards. So I created a replication but when it comes to start the snapshot agent, the ...
2
votes
0answers
64 views

How to Remove Articles Based on User

I am using merge replication on SQL 2012. I have a very large database with a large number of tables. The subscribers are using netbooks. I have a filtering scheme that controls which tables end up ...
1
vote
1answer
381 views

Merge Replication Snapshot Files

I am using Merge Replication with SQL 2012. I look in the snapshot directory, but the largest file in there is a prc file which is 646 KB. I know for sure that the biggest of my replicated tables is ...
1
vote
2answers
723 views

Merge Replicate and Mirrors

I am preparing some scripts to setup merge replication in our production environment. After completing the export from UAT, I've come across something that doesn't appear like it would work in the ...
2
votes
2answers
1k views

How To Set Up Web Synchronisation With IIS 7.5

I set up merge replication web sync using a pull subscription. When I try to start the merge agent at the client side I get this error, The Merge Agent could not connect to the URL 'http://address....