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
2
votes
3 answers

SQL Server 2005 Replication Integrity Violations SQL Server, Error number: 28549

I am hoping someone can help me with a really bizarre problem. When users sync their device they are getting this error: The row operation cannot be reapplied due to an integrity violation. Check the Publication filter. [ Table = …
Morrislgn
  • 3,717
  • 4
  • 24
  • 26
2
votes
3 answers

drop a foreign key constraint for replicated table

Can I drop a foreign key contraint from a table participating in merge replication? If so, can i just drop it from the published and will this chnage be replicated to all subscribes?
imak
  • 6,489
  • 7
  • 50
  • 73
2
votes
1 answer

Replication - User defined table type not propagating to subscriber

I created a User defined table type named tvp_Shipment with two columns (id and name) . generated a snapshot and the User defined table type was properly propagated to all the subscribers. I was using this tvp in a stored procedure and everything…
Thakur
  • 1,890
  • 5
  • 23
  • 33
2
votes
3 answers

How to: Configure IIS7 for Web Synchronization

I have followed the instructions here. To cut a long story short, I just cannot connect to: https://machine/site/virtual directory/replisapi.dll?diag I get: HTTP Error 500.0 - Internal Server Error Module IsapiModule Notification…
DomBat
  • 1,981
  • 5
  • 27
  • 42
2
votes
1 answer

Help determining proper Identity Range sizes

I have a Merge Replication with ~200 subscribers. I am trying to determine what would be appropriate Identity Range Sizes on some of the tables. You see I inherited a DB structure that was not designed for Replication therefore all table PK's are…
Refracted Paladin
  • 12,096
  • 33
  • 123
  • 233
2
votes
0 answers

SQL Server Merge replication: "Thread xxxx successfully re-established connection to Subscriber xxxxxx"

I have problems with SQL Server merge replication and it does not work. Not so long ago, it was working. But recently we encountered this problem. And data transmission can not give up. Setting timeout agent profiles raised and therefore do not have…
sajad Ahmadi
  • 21
  • 2
2
votes
1 answer

Stored Procedures aren't replicated in Merge Replication

I am replicating a database using merge and had an issue where if the developers changed a procedure on the original database the change would not be pushed to the replicated database. Replicate schema changes is set to True. Any guidance reason…
Jersey
  • 151
  • 1
  • 7
2
votes
1 answer

Merge replication Error: The process could not bulk copy into table

Hi I am using SQL SERVER 2005 Service pack 4 on both publisher and distributor. While trying to setup merge replication, i am getting below error continuously. Below are replication details. I am using push subscription and path is network path.…
vidyadhar
  • 3,118
  • 6
  • 22
  • 31
2
votes
1 answer

Suggestions on on-going development of database schema when it's under replication

I'm currently working on a database that comes with a legacy project which uses EntityFramework (updates code based on existing database using Data Model Designer) Currently I work on the master copy and our developers work locally using SQL Server…
Lida Weng
  • 476
  • 6
  • 20
2
votes
1 answer

Find deleted row from Merge Replication

Merge Replication creates a table named MSmerge_tombstone, it records all deleted rows. My question is, how can i find this deleted row? This row's Data is recorded in any table?
Alexandre_Almeida
  • 131
  • 1
  • 3
  • 10
2
votes
1 answer

Merge Replication Primary Key Violation

I have a Publisher and a Subscriber, Sometimes they insert the same row at the same time, when I run the JOB for Merge Replication I have a PRIMARY KEY violation. I have a UK (Col1, Col2), a PK (uniqueidentifier) and the MERGE REPLICATION adds a…
Alexandre_Almeida
  • 131
  • 1
  • 3
  • 10
2
votes
1 answer

What to consider if using triggers on tables in a sql-server merge replication

i am driving since some years a sql-server2000 merge-replication over three locations. Triggers do a lot of work in this database. i got no troubles. Now migrating these database to a brand new sql2008, i got some issues about the triggers. They are…
Ice
  • 1,162
  • 3
  • 14
  • 27
2
votes
1 answer

Preserver Filegroup on Subscriber in Merge Replication SQL Server 2008R2

How do you preserve the File Group on the Subscriber of a Merge Replication Publication? I created identical databases with 3 filegroups for various groups of tables, assigned to the appropriate filegroups when the tables were created. The first…
Chris Morgan
  • 115
  • 1
  • 12
2
votes
1 answer

SQL Server merge replication permissions issue

I have a merge replication set up, with a publication on our dev server (SQL Server 2008 R2 SP2) and a subscription on my local machine. The publisher is acting as its own distributor. The publisher and distributor connections in the subscription…
user1360192
  • 53
  • 1
  • 4
2
votes
2 answers

How to handle SQL Merge Replication Conflicts

I have a situation that I am looking for some guidance on. I have 4 SQL 2008 databases that are syncronized over the internet using merge replication. 1 publisher and 3 subscribers. Normally records that are entered on a databases are also only…
SDGarrod
  • 43
  • 1
  • 7
1 2
3
…
17 18