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

SQL SLEEP_BPOOL_FLUSH wait. Unable to Re-Initialize a Merge Push Subscription

I am trying to initialize a merge subscription but it fails and gives error that Query timeout expired. The merge process failed to execute a query because the query timed out. If this failure continues, increase the query timeout for the process.…
Thakur
  • 1,890
  • 5
  • 23
  • 33
0
votes
2 answers

Distributed Database

I NEED YOUR HELP ANY IDEA ANY SOLUTION SCENARIO: An organization suppose Jason industries have its branches in different regions of country. In each branch there is a local database where they maintain their data locally. Suppose one branch in…
Abdul Majid
  • 95
  • 1
  • 10
0
votes
1 answer

Cannot insert duplicate key row in object 'dbo.MSmerge_contents' with unique index

We have Merge replication configured between 1 publisher and 12 subscribers all having SQL server 2008 R2 On one of the subscription I am getting below error Error messages: The merge process could not replicate one or more UPDATE statements to the…
Thakur
  • 1,890
  • 5
  • 23
  • 33
-1
votes
1 answer

SQL Server encountered one or more errors while retrieving information about publication 'C01_repl_01'

I am trying to establish a merge replication in SQL Server 2017 (edition) using SQL Server Management Studio 19.0.20196.0. I am following the Microsoft documentation to achieve the goal, but I am getting an error after creating a publication. I…
younes abdenacer aitemrar
  • 1
  • 2
-1
votes
1 answer

SQL Replication, CE device

I have a Windows CE device that I'd like to replicate data to a SQL Server 2008 R2 database. I understand the basics of replication and I need to use MSDN's "Two-Server Topology". Where there is an IIS box and a separate SQL Server box. I have…
Blaze
  • 1,863
  • 7
  • 23
  • 40
-1
votes
1 answer

How to find out more on error in merge replication in SQL Server?

Error that we are getting is: Error converting data type nvarchar to numeric. (Source: MSSQLServer, Error number: 8114) This kind of error is not so descriptive so we don't know where to look next. Does anybody know where to look on more…
Dejan Dozet
  • 948
  • 10
  • 26
-1
votes
1 answer

ComErrorException 'Class Not Registered'

I'm trying to write a integration(unit) test that calls an object from SQLServer Replication dll. When it tries to instanciate the object MergeSynchronizationAgent i get an exception: '{Class Not Registered}' -2147221164 I tried switching the…
TMan
  • 4,044
  • 18
  • 63
  • 117
-1
votes
1 answer

How to get Merge Push Subscription status?

I have Merge replication setup with Push subscriptions. I read the following article: Implementing a replication agent progress bar It is working fine if I initiate the agent from the subscriber, but the Status event of the MergeSynchronizationAgent…
Adel Khayata
  • 2,717
  • 10
  • 28
  • 46
-2
votes
1 answer

SQL Server 2008 R2 Merge Replication Change Identity management on an article

I have inherited a merge replication publication nightmare. There is an article that is being published but it does not have an Identity Range being set for either the publisher or subscriber yet is set to manual Identity management. I would like to…
Jersey
  • 151
  • 1
  • 7
1 2 3
…
17
18