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

Web Sync Replication: (0x80004005): The schema script 'xxx' could not be propagated to the subscriber

Ive been having great trouble setting up replication (web sync via HTTPS). If I only publish the tables, they replicate fine with the data. If I add in views & sprocs then it failes with the message: ComErrorException (0x80004005): The schema script…
DomBat
  • 1,981
  • 5
  • 27
  • 42
0
votes
1 answer

SQL Replication Lost Transactions

Firstly, my SQL Server Replication knowledge is not massively great so apologies if I've missed anything obvious so far! I have a master database with 9 merge replicating subscribers all of which have been working fine for a couple of years now. I…
Gavimoss
  • 365
  • 2
  • 4
  • 22
0
votes
3 answers

SQL Server 2008 Replication to SQL Express 2005 via web sync

I have a SQL 2008 R2 server. I've created a publication using the wizard which seemed to go ok. There is a 'distribution' database in the 'system databases' section that has not a lot in it. (Not sure if this was there already or whether the…
DomBat
  • 1,981
  • 5
  • 27
  • 42
0
votes
0 answers

How to avoid Insert and Update conflict in SQL Server Merge Replication?

I have developed a web application using Asp.net Rest Api, Entity Framework code-first approach. I have publisher with 20-30 subscribers. All my subscribers may work online or offline. After setting up merge replication, I have faced insert and…
angfreak
  • 993
  • 2
  • 11
  • 27
0
votes
0 answers

identity seed lost efter publishing new table in merge replication

I have a merge replication in MSSQL 2008 and a little over 200 windows mobile 6 clients that subscribes to this replication. When I publish a new table in the replication, for some reason, every subscriber loses identity seed after they make a sync.…
Dratskapoo
  • 11
  • 5
0
votes
0 answers

Add article to SQL Server merge replication with partially snapshot initialization

I have a merge replication scenario with one publication and multiple subscriber. I have also a two types of tables. First base tables that has the same in all subscriber. Second, multiple table that have same structure in all subscriber but with…
Jalal Sakhdari
  • 1
  • 1
0
votes
1 answer

How can I get the updates and Changes in all masters in a Multi-Master Replication?

I have configured Mysql Ring replication say as Servers A,B,C. I can get the changes and updates in B when I commit the updates in A. I get it in C when I make changes in B. I get updates in A when I make it in A. My issue is that I cannot get any…
Narasimman
  • 11
  • 3
0
votes
1 answer

SQL SERVER 2016 - Distribution Server compatibility

Can you create an SQL SERVER 2016 distributer that merges data between a 2008 R2 server to another 2008 R2 server?
Jersey
  • 151
  • 1
  • 7
0
votes
0 answers

newseqeuntialID vs bigint on replicated database

I recently started working on an application that has merge replication for offline scenarios. We have an int identity column that serves as the pk and clustering index. We also have uniqueidentifier column in each table because replication needs…
May
  • 100
  • 1
  • 9
0
votes
1 answer

Can't create snapshot agent for SQL Server 2016 publication

Just installed a SQL Server 2016 instance fresh. Previously I've used merge replication for 2008 and 2012 without issues. I'm trying to do the same here, and while I can create the publication no problem, I get the following error when I try to…
Phil
  • 1,852
  • 2
  • 28
  • 55
0
votes
0 answers

Is Referential integrity between tables mandatory for custom conflict resolver in sql merge replication?

I have a database which have multiple tables but these tables have not any relationship define(Referential integrity) in database. They are related to each other but maintained by trigger and application. I have created custom conflict resolver on…
Deepak Joshi
  • 1,036
  • 7
  • 17
0
votes
1 answer

merge replication taking longer with "Downloaded snapshot file '*****_9.bcp'"

I have a merge replication on sql server 2012 with five subscribers. I reinitialised one of the subscribers to replicate all the data from the publisher but It takes the whole day downloading the snapshot. At the publisher I see the following…
mox-du
  • 107
  • 9
0
votes
1 answer

Merge Replication with Static Filters - Does not Delete from the subscriber database?

I have a merge replication setup, I have applied static filters so as to send only specific rows to the subscribers from a publisher (table) say 'X' the filter is " where Name Starts with ( Select sub-query which returns 'T') ". Now after sync the…
Saurabh
  • 241
  • 2
  • 12
0
votes
1 answer

SQL Merge Replication Issue

I have a issue regarding Merge Replication. I have a table SETTINGS where in i store the settings of my software. The schema of the table is ID ( PK) , Description , Value. Suppose i have 15 rows in this table on my server. Now i have applied…
Saurabh
  • 241
  • 2
  • 12
0
votes
1 answer

Refresh sysdepends for a table

I have tables in a merge-replicated database that don't show any entries in sysdepends (both at the publisher and subscriber and event on my empty testing development database). This means that the merge agent has to re-try a lot of operations as…
Tom Mayfield
  • 6,235
  • 2
  • 32
  • 43
1 2 3
…
17 18