Skip to main content

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.

70 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
1 answer
141 views

Merge Replication: Updates to Schema

We have a main SQL Server which replicates to two backup servers via continuous merge replication. There are regular updates to the schema. Regular changes include: Adding new tables and ...
j7m's user avatar
  • 141
4 votes
0 answers
301 views

merge replication too big

I have multiple handhelds which sync their data via merge replication. From time to time, new core data is imported on the server-database. For various reasons I keep the old data in the databse and ...
abc's user avatar
  • 183
4 votes
0 answers
122 views

Merge Replication Optimization

I am running Merge Replication on Microsoft SQL Server 2012 through web sync. Is there a way to recognize when regenerating a new snapshot and applying it would be more efficient than running a merge?...
peter's user avatar
  • 2,187
3 votes
0 answers
752 views

Merge replication subscriptions are repeating the same actions endlessly

We have a merge publication set up on SQL Server 2008R2, with several subscribers. Synchronisation is done through the internet. Over the last few days, some subscribers are unable to synchronise. In ...
George T's user avatar
  • 245
3 votes
0 answers
2k views

"The schema script could not be propagated to the subscriber" error has SQL code instead of file name

This type of error is unfortunately not uncommon. One report of many is this one on Stack Overflow: https://stackoverflow.com/questions/11360331/sql-server-merge-replication-error-the-schema-script-...
George T's user avatar
  • 245
3 votes
2 answers
1k views

Syncronize mysql databases between local and hosted servers automatically

We have many websites with Development, Staging and Production servers. We have many developers for many projects. We need a solution to synchronize the developer and staging databases. After that one ...
Sudha's user avatar
  • 31
3 votes
0 answers
744 views

Uninitialized Merge replication subscription

I have 3 separate SQL Server 2012 databases running on 3 VM's. I have successfully configured one pull subscription to the distributor but when I add a 2nd subscription on another SQL Server the ...
Syn's user avatar
  • 31
3 votes
0 answers
243 views

How To Diagnose Slow sp_mssetupbelongs

I am using merge replication with SQL 2012. When performing a clean sync using the merge agent I am getting a timeout on this stored procedure, sp_mssetupbelongs I am wondering what the best way to ...
peter's user avatar
  • 2,187
3 votes
0 answers
192 views

MSMerge_contents Table Populated After One Sync

I am running merge replication with SQL 2012. When I first create my publication the MSMerge_contents table is populated with a large number of records with the colv1 being set to 0xFF. When I run ...
peter's user avatar
  • 2,187
3 votes
0 answers
312 views

SQL Server 2008 R2 - Merge Replication - Can the Distribution Database size cause replication problems?

Setup: We have a SQL Server 2008 R2 instance running on a central server. The server is a merge-replication publisher. We have 'N' subsribers running SQL Server 2008 Express. 'N' can grow to any ...
user avatar
3 votes
0 answers
310 views

Merge replication sync fails after ALTER TABLE... NOT NULL

We have a SQL Server 2005 database that uses merge replication to sync to SQL Compact Edition subscriptions. We added a column to a table using: ALTER TABLE Shifts ADD COLUMN StateOrProvince NOT NULL ...
user avatar
2 votes
0 answers
361 views

Merge replication Locking on MSMerge_genHistory Table and lots of unhappy chickens

I do contracting with about 10 chicken farms. Each chicken has a GUID so we can track it through the entire life process (govt. requirement). We have 2 million chickens in the tables at any one time....
IMeitzen's user avatar
2 votes
0 answers
217 views

Database replication/synchronization using multiple source nodes for postgresql

What would be the approach for synchronization at DB level for a scenario where data from multiple sources (DB nodes) needs to be integrated at a destination DB node when using PostgreSQL? The ...
S_S's user avatar
  • 121
2 votes
0 answers
259 views

MS SQL Server merge replication cannot find file specified

I'm trying to setup merge replication between two MS SQL Server 2012 databases on different hosts in one domain. When replication is set up and first snapshot is generated replications starts. ...
nidu's user avatar
  • 121
2 votes
0 answers
320 views

SQL SERVER 2008 R2 - Merge Replication - Identity Seed issue

The server I am running has identity Management set to automatic for most of the tables I am replicating (A hand full have been set to manual). When the replication goes to change the range it ...
Paul Baratelli's user avatar
2 votes
0 answers
119 views

How to prioritise delete and update based on timestamp during replication?

We have two MS SQL Server 2012 servers running merge replication. We have used the SQL Server DATETIME (Later Wins) Conflict Resolver to resolve conflicts based on the latest updated time. However, ...
arpith03's user avatar
2 votes
0 answers
2k views

Merge Replication: Error "The insert failed. It conflicted with an identity range check constraint"

For one of our SQL server 2005 enterprise, configured with merge replication, we suddenly start seeing the below error message: The insert failed. It conflicted with an identity range check ...
KASQLDBA's user avatar
  • 7,167
2 votes
0 answers
114 views

Transaction log bloat when writing to table on replicated database with parameterized filter

We are observing abnormally large log writes whenever we update a table that is used for parameterized filter in a merge replication. There are a number of join filters as well. When executing a ...
this's user avatar
  • 166
2 votes
0 answers
254 views

Merge-Replication: New column doesn't get replicated down by update command

I do this frequently but all clients have this fault: I added a new column to a table using a SQL statement, which causes the column to be created and added to every publication that uses this table. ...
Daniel's user avatar
  • 181
2 votes
0 answers
391 views

Why are foreign keys ignored on subscribers?

We are using merge replication on SQL Server 2008 R2. There are many tables with foreign keys providing a logical dependence on each other. For this question, let's say there are User and File tables, ...
George T's user avatar
  • 245
2 votes
0 answers
122 views

Replication stopped working, no errors

I have a TOP server (SQL Server 2012) with a merge replication to around 4 other servers. When I subscribe to the publication, everything is downloaded fine to the subscriber. The insert of one of ...
irco's user avatar
  • 121
2 votes
0 answers
735 views

The replication Merge Agent failed to propagate a Publisher schema change to the Subscriber

We are running 2 Microsoft SQL Servers - publisher (2008R2) / subscriber (2008 Express) with merge replication. I tried to make some schema changes via Transact-SQL and partly failed. So tried to ...
Barry Nelson's user avatar
2 votes
0 answers
135 views

Identifying connection and publisher vs subscriber in merge replication scheme

We have an app that uses a central SQL Server 2008 database for folks here in the building on the domain. For teams out in the field - they connect to a local version of SQL Express while offline and ...
RThomas's user avatar
  • 3,396
2 votes
0 answers
71 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 ...
peter's user avatar
  • 2,187
2 votes
0 answers
97 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? ...
peter's user avatar
  • 2,187
2 votes
1 answer
253 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 ...
peter's user avatar
  • 2,187
1 vote
0 answers
337 views

SQL Server Merge Replication Error: The format of a message during Web synchronization was invalid

I am doing Merge Replication using Web Synchronization. On Subscriber end, there is SQL Express 2012 on Windows 10 Pro. On publisher end, there is SQL Server 2016 on Windows Server 2016. Web ...
Muhammad Bilal's user avatar
1 vote
0 answers
75 views

How to find out more on error in merge replication on mssql server?

How to find out more on error in merge replication on mssql server? Error that we are getting is: Error messages: Error converting data type nvarchar to numeric. (Source: MSSQLServer, Error number: ...
Dejan Dozet's user avatar
1 vote
0 answers
106 views

Merge Replication Business Logic Handler Incorrect Encoding when connecting to SQL Server

We have a SQL Server Merge Replication configuration that uses a business logic handler to do conflict resolution on a datetimeoffset column. All we're doing is a copy of the Subscriber or Publisher ...
Jason's user avatar
  • 66
1 vote
1 answer
441 views

SQL Server Merge Replication Computed Column Conflict Resolution

I'm setting up a merge replication web publication for a table that needs to use the DateTime (Later Wins) conflict resolver so that the most recently modified row wins in any conflict. This table (...
Jason's user avatar
  • 66
1 vote
0 answers
86 views

Anonymous subscribers does not get expired in merge replication

I have a Merge replication with anonymous subscribers, in my sysmergesubscriptions there are old subscriptions that still has the status 1 (active) and the last_sync_date is way below the ...
Dratskapoo's user avatar
1 vote
0 answers
428 views

Merge replication Problem

I have got some problem to implement Merge Replication in SQL server 2008 R2 which send me the error response at the time of Synchronization using PULL from Publisher. I have tried to solve the ...
Emrul Kayes's user avatar
1 vote
0 answers
314 views

High CPU usage occurs periodically on the subscriber

I have set up a merge publication and a subscriber with push subscription mode. On the subscriber, I notice the CPU usage is going high periodically. It may take about 40 seconds for the CPU Usage ...
joe's user avatar
  • 135
1 vote
0 answers
316 views

Merge Replication - set up new subscriber based on backup of publisher and last snapshot (object definitions only)

I have a replication setup with 1 publisher and 3 push subscribers. I need to add a new push subscriber. I cannot afford downtime for the publisher and the existing subscribers. My plan is to do the ...
Gabrielle's user avatar
1 vote
0 answers
46 views

Database Replication or Single Point?

We have a Database and web application hosted in our office in Middle East, and we have 2 more sites in Philippines and USA. Both offices in Philippines and USA are using the same hosted Web ...
Abey Mohamed El-Sheemy's user avatar
1 vote
0 answers
795 views

SQL Server 2008 R2 sp_replmonitorrefreshjob Issues

My team just moved our production SQL Server VM from one machine to another. During the move we also applied server updates. After the move was completed, everything tested as a successful move. ...
Jersey's user avatar
  • 99
1 vote
0 answers
568 views

Merge replication: some subscribers initializing by downloading changes multiple times

I have a database in merge replication with about 25 subscribers, all accessing the publisher/distributor over a satellite connection (high latency, low bandwidth). Recently, as part of a planned ...
Agbullet's user avatar
1 vote
0 answers
295 views

Merge Replication query causing slow performance

I have three databases (one publisher, two subscribers) running merge replication and this morning noticed very slow performance. They sync on 10 second intervals but this morning it was taking much ...
tmwoods's user avatar
  • 145
1 vote
0 answers
573 views

Query slow on subscriber but fast on publisher (Merge Replication)

As the title suggests, I am having issues with performance with my subscriber. I run the exact same query (it's a recursive query with a few joins but nothing too serious). I can run this query on my ...
tmwoods's user avatar
  • 145
1 vote
0 answers
162 views

SQL Server 2012 Merge replication not replicating all changes

Having a problem with replicating a database between two servers, both running SQL Server 2012. We have a table where each site that stores the database updates a record every minute with the current ...
GreyArea's user avatar
1 vote
0 answers
380 views

How to manage old replication issue

Background We are using SQL Server 2008 and we had a merge replication configured (before i joined the company). After that they stopped using it and the didn't delete it and configured transactional ...
Sami's user avatar
  • 11
1 vote
0 answers
366 views

Replicating Multiple SQL Servers to Azure and Accessing From Web Apps

I am setting up quite a large system with multiple servers (MS SQL Server), and Office 365 Access DB, and a custom SharePoint web app for reporting purposes. The system should work as follows: Each ...
Kevin's user avatar
  • 11
1 vote
0 answers
545 views

Row not being deleted from the publication when it's deleted in a subscription

We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by default merge replication is bi-directional. Its working fine in case of inserts i.e, if a row is ...
nadeem's user avatar
  • 11
1 vote
0 answers
1k views

Merge Replication Update Statement Timeout

I work for a company that provides web based data collection. Currently we have a SQL Server 2012 server as the publisher for 2 subscribers (planning on expanding up to 5+ subscribers), both SQL 2012 ...
StMotorSpark's user avatar
1 vote
0 answers
867 views

How to delete orphaned records from sysmergesubscriptions table?

I have some old orphaned records for old subscriptions that I want to delete from the sysmergesubscriptions table. Each time I delete unnecessary records, it show up again after it syncs with any ...
Adel Khayata's user avatar
1 vote
0 answers
79 views

How To Use Publication Without Precompiled Partitions

I am using SQL 2012 with merge replication. Our setup is quite complicated and thus it seems running the publication with precompiled partitions is not going to work. The merge agent is slow to do ...
peter's user avatar
  • 2,187
1 vote
1 answer
72 views

Merge Replicate, reinitialise with a different part of the data

I have a set of database with merge replicate configured between them. The publisher is an aggregate of three sets of data. Call them set 0, 1, and 2 There are subscribers that grab one set of the ...
M Afifi's user avatar
  • 227
1 vote
0 answers
84 views

Merge Replication Finding Session Id

I am using merge replication with SQL 2012. I am writing a custom business logic handler, and would like to know if there is a way to get a session id? For instance if the custom business logic ...
peter's user avatar
  • 2,187
1 vote
0 answers
1k 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 ...
RThomas's user avatar
  • 3,396
0 votes
0 answers
19 views

Problem with SQL Server Merge Replication 2017

I have multiple replications: merge replications that sync the data on both Headoffice and Stores but from past two days I am getting these error messages and replication doesn't complete successfully ...
Haider Mumtaz Khan's user avatar