Stack Overflow
Stack Overflow

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.

Merge replication starts with a snapshot of the publication database objects and data. Subsequent data changes and schema modifications made at the Publisher and Subscribers are tracked with triggers. The Subscriber synchronizes with the Publisher when connected to the network and exchanges all rows that have changed between the Publisher and Subscriber since the last time synchronization occurred.

More information: Merge Replication.

264 questions
0
votes
1 answer

Merge Replication Unique Key Constraint

I have SQL Server Merge Replication setup on two servers and I am getting a key constraint error when the synchronization runs. The only way I can resolve this issue is to delete the record on one of the servers and then run synchronization. …
Shawn Palmer
  • 321
  • 3
  • 5
0
votes
0 answers

Merge Replication Failing

I have 3 databases replicating using merge replication. All servers are running SQL Server 2008. The replication had been running fine for years. About a month ago one of the subscriber databases failed and had to be rebuilt. After it was rebuilt,…
SDGarrod
  • 43
  • 1
  • 7
0
votes
0 answers

SQL Replication Running ALTER VIEW against a table

I have SQL Server Replication running between a Publisher and 2 subscribers. Publisher: Microsoft SQL Server 2008 (SP3) - 10.0.5538.0 (X64) Apr 3 2015 14:50:02 Copyright (c) 1988-2008 Microsoft Corporation Workgroup Edition (64-bit)…
SDGarrod
  • 43
  • 1
  • 7
0
votes
1 answer

Complex filter for SQL Server Merge Replication

We have a table in an SQL Server 2012 database that stores tree-like structures. Simplified for the purpose of my question, it has the following format: Id int identity, ParentId int, GroupId int Each record of the table represents an…
alexk
  • 143
  • 1
  • 11
0
votes
1 answer

Violation of PRIMARY KEY constraint during Merge Replication

I have two identical SQL Server 2005 databases (MYDB_Pub, MYDB_Sub1) where the merge replication was configured and it works fine. Recently we upgraded to SQL Server 2014. To test the replication functionality on the new SQL Server I followed the…
A J Qarshi
  • 2,772
  • 6
  • 37
  • 53
0
votes
1 answer

merge replication processing order of UPDATEs, INSERTs and DELETEs

I can set the order of Merge Replication? I've read that the order is Delete -> Update -> Delete. I can change it? If so, how can it impact in my replication?
Alexandre_Almeida
  • 131
  • 1
  • 3
  • 10
0
votes
1 answer

Merge Replication First Snapshot don't work

When doing the First Synchronization in Merge Replication, I'm having this error: "Cannot delete table 'dbo.eqp_Equipment' because it is being referenced by a FOREIGN KEY constraint. (Source: MSSQLServer, Error number: 4712)" Then I changed the…
Alexandre_Almeida
  • 131
  • 1
  • 3
  • 10
0
votes
2 answers

Adding FK Index to existing table in Merge Replication Topology

I have a table that has grown quite large that we are replicating to about 120 subscribers. A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing issues it had this to say --> /* Missing Index…
Refracted Paladin
  • 12,096
  • 33
  • 123
  • 233
0
votes
1 answer

Local subscriptions error while connecting to remote publisher

I am new with merge replication so non sense can be expected, What i did. 1) New Local publication done is on remote server. When i am trying to do local subscription with remote server for selection of publication server, in server name i used…
Hot Cool Stud
  • 1,145
  • 6
  • 25
  • 50
0
votes
1 answer

Merge Replication Status

I was working on a merge replication on SQL SERVER 2012. I have one central server with the publication and distribution configured on the same machine.I have another three machines with SQL SERVER 2012 as subscribers. The replication is working…
mox-du
  • 107
  • 9
0
votes
1 answer

Slow merge replication over a WAN link - only downloads

We've been using SQL Server merge replication for a few years to synchronise data between our data centres, but we are now suffering with a big performance issue. This may be because the amount of data we are synchronising has increased a lot this…
Mark E
  • 43
  • 9
0
votes
1 answer

Real-time SQL Inserts Over Unreliable Network

I need to insert a 5K records every minute over an "unreliable" Internet connection to a cloud-based database (from different 10 systems all running simultaneously). The Internet connection is 10 MB and my app needs to tolerate an outage once a…
Charlie
  • 2,004
  • 6
  • 20
  • 40
0
votes
0 answers

Merge replication unintialized subcription is expired or does not exist

I am trying to set up a merge replication using web synchronization between a publishing SQL Server 2012 standard and subscribing SQL Server 2012 Express. After following the instructions provided at Technet, I am stuck on this: Source: Merge…
this
  • 1,406
  • 11
  • 23
0
votes
1 answer

The 'Microsoft SQL Server Subscriber Always Wins Conflict Resolver' failed to resolve the conflict

I'm using merge replication to keep publisher database and subscriber database in sync. I changed the conflict resolver to 'Subscriber always wins'. Now, to test this, I force a conflict by changing a value of the same row both on server and client.…
TMan
  • 4,044
  • 18
  • 63
  • 117
0
votes
1 answer

Installing Correct Version of Microsoft.SQLServer.Replication.dll

I have written an application to control a merge replication process on a sql server. It is running on my development machine with no problem. On my test install I have installed a SQL Server 2008 R2 64 bit on Win 7 64 bit. When I try to use my…
PlTaylor
  • 7,345
  • 11
  • 52
  • 94
1 2 3
…
17 18