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.

learn more… | top users | synonyms

2
votes
1answer
685 views

Merge Replication: Where are rowguids of conflict losers stored?

I'm trying to obtain the row guid of all the merge replication conflict losers listed in my conflict viewer. The bug that was allowing the conflicts to occur has been identified and resolved but now ...
2
votes
1answer
418 views

How to Rename Table or Field With Merge Replication

I am using merge replication with SQL 2012. I am trying to rename a published table, and rename a published field. These operations are not permitted in merge replication. However I can think of an ...
1
vote
0answers
480 views

Dropping One Computed Column Causes All Computed Columns To No Longer Replicate

We recently dropped a computed column from a table that was participating in merge replication. After issuing the statement the other two computed columns remained in the table but stopped ...
9
votes
2answers
683 views

Hard limitation for merge replication article count?

A bit of background. We developed an app that uses merge replication. Right now, we are currently publishing about 212 articles, and everything is fine, as it appears to fall into the 256 article ...
2
votes
1answer
461 views

How to user the Tablediff Utility with Replication Filters

I am using merge replication in SQL 2012. I am trying out the TableDiff utility to show non convergence. I see a problem with this approach though. This is because I am using parameterised filters to ...
2
votes
1answer
57 views

What else does sp_addmergefilter do

I am running the following stored procedure to add a merge replication join filter, sp_addmergefilter What else does that stored procedure do behind the scenes? I am calling that stored procedure ...
1
vote
1answer
315 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 ...
2
votes
1answer
344 views

Why would “Drop Database” fail on local SQL Server 2005 Express instance?

I am trying to run the below code. It works for me but not for at least some of my users it doesn't work. It doesn't seem to error just no actually remove the DB's. string sqlConnectionString=@"Data ...
1
vote
1answer
245 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
685 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
61 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 ...
3
votes
0answers
83 views

How Much Overhead Does Web Sync Add?

I am running merge replication in SQL2012 using web sync. Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection? ...
1
vote
0answers
328 views

How To Speed up Merge Replication [closed]

I am running SQL2012 merge replication on a netbook using SQL Express as a subscriber. The netbook has 1GB of RAM. The replication process works quite well, but it is when it comes to applying the ...
3
votes
1answer
153 views

Merge replication with PDAs AND P2P replication between servers?

We're currently building a setup to scan tickets at an event. We plan on having 2 servers at each entrance but can't have a local link between the two. We have scanners (sqlCE) and half of them are ...
1
vote
1answer
247 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 ...
4
votes
1answer
124 views

Is there a way to start a script on the publisher when synchronization starts?

I am using merge replication with pull subscriptions and Web Sync. What is the easiest way to start a SQL script on the publication database when a subscriber starts the synchronization process? ...
6
votes
2answers
1k views

Working Around Filtering Problems in Merge Replication

I am in the process of defining filters on a merge replication publication for our database. The problem I am coming up against is that merge replication has these rules, I don't like to call them ...
0
votes
2answers
467 views

Merge Replication Subquery Filters

I am using merge replication with SQL 2012. I have a number of articles in my publication and will have to come up with quite an elaborate set of filters. If I add a filter on my article it can ...
1
vote
2answers
414 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 ...
3
votes
2answers
383 views

Replicating a Table Structure With no Data Using Merge Replication

I am using merge replication with SQL 2012. I have a table, and it would be useful to propogate that table to the subscribers, but just the table structure, not the actual data. The data in the ...
0
votes
1answer
335 views

Can You Replicate Sequences

In SQL 2012 can you replicate sequence objects, and if so do changes to the sequence (including consumption of values) get replicated? If not is there a good reason why this was not included?
1
vote
1answer
116 views

How to tell what user has synced

I have set up merge replication web sync to sync a publication from a SQL Server 2012 database. I am trying to make some parameterised filters using SUSER_SNAME() or HOST_NAME(). When I do a sync is ...
3
votes
1answer
137 views

How to update conflict resolver when upgrading from SQL-Server 2005 to SQL-Server 2008

We have recently upgraded from SQL Server 2005 to SQL Server 2008 (R2, SP1). This upgrade included some publications, where all tables are published with a default conflict resolver based on the ...
2
votes
2answers
542 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 ...
2
votes
1answer
435 views

How does merge replication work with SQL Server CE

I have been trying out merge replication with SQL Server databases, and was just wondering how merge replication works on SQL Server CE? For instance merge replication with SQL Server databases ...
3
votes
1answer
298 views

Transactional versus Merge Replication (Restore backup after downtime)

I have the following transactional replication setup: Windows Server 2008 with SQL Server 2008 Enterprise Server A: Master, has a database with a table, publisher Server B: Slave, subscriber ...