Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
15 views

Merge ReplicationWhy are uploads from subscriber 5 times slower than downloads on the subscriber

I have a merge replication environment configured between a PUBL and 5 SUB servers that are geo distributed. Most of the activity is at the publisher ( i know not the best direction- working on ...
0
votes
2answers
30 views

SQL Server Replication, is it possible to have “upload only” syncronization on some articles?

Within SQL Server's merge replication, I know how to make publication's article download-only (either with update restrictions on subscriber database or not) - @subscriber_upload_options parameter in ...
0
votes
0answers
13 views

SQL Server Merge Replication, dealing with existing tables

I have publisher and subscriber databases with identical schema, while some of the tables participate in replication and some don't. In some cases it is possible to have tables that have referential ...
1
vote
0answers
22 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: ...
0
votes
1answer
44 views

Added New Subscriber but Replication Not working

I have one Merge Replication setup with one Publisher and 5 to 6 Subscribers. We have added one additional subscriber to this replication and when we try to sync it's giving the following error. ...
1
vote
1answer
48 views

Foreign key constraints check during replication?

I am a little bit new to replication and can't seem to find an answer to this anywhere. Let's say I have a simple relation in my database: Department table with Code column as PK and Person table ...
0
votes
0answers
22 views

SQL Server replication model snapshot, transactional and merge - which method can be used

I am trying to implement sql server database replication between 2 branch servers to a Head Office Server. My application is a distributed one, the main application is hosted on head office which is ...
0
votes
1answer
57 views

REPLMERG.exe cannot connect to distributor

We have a SQL Express 2016 instance that is doing merge replication to a SQL 2016 box. This is an upgraded instance on both sides. We upgraded from SQL Express 2012 to 2016 and we moved the database ...
2
votes
1answer
89 views

How to run merge agent job step on tsql

I'm having a problem with the merge replication and I want to try and run the job as a script on ssms so I can see the errors (I've tried almost everything else) Original post Here is the script -...
0
votes
1answer
56 views

Cannot set up replication between two servers

I am trying to subscribe a 2016 (sp2, cu1) server to another 2017 server. I am getting the following error message: For merge publications, the version of the Subscriber must not exceed the version ...
0
votes
0answers
49 views

SQL Server 2014 Triggers and Merge Replication

I am trying to have a trigger fire when the Merge agent\user insert\delete\update data. The trigger inserts data into a log table. I don't want to use NFR (Not For Replication) because I need that the ...
0
votes
1answer
73 views

Merge replication - Could not remove directory

We are facing an issue with our replication server. We are currently setting up a new environment to replace the old replication server and we keep getting the following error. Server XXX\YYY, Level ...
1
vote
1answer
44 views

Triggers corrupt merge replication

I have merge replication (SQL server 2014) and a table that have 3 triggers that monitor delete, insert and update. All of the triggers are after trigger not instead of. I'm updating the value on one ...
1
vote
1answer
11 views

Switch publisher - subscriber side

I have 2 server using merge replication. One acts as a Publisher and one acts as a Subscriber. One day I want to switch the side, publisher become subscriber and subscriber become publisher. In my ...
2
votes
0answers
32 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 ...
2
votes
1answer
46 views

Declare table as not replicable

How can I make sure that a certain table is not selected as an article in a publication? So that this table is never replicated (even by error). The replication for the database is setup by different ...
2
votes
1answer
40 views

SQL Server Replication changing a tables ID numbers

I am using a merge replication setup for our ERP system and I encountered this problem: While creating a new entry on a table and with the last ID number given was 25, then new entry got the ID ...
0
votes
1answer
55 views

Replication Monitor - Start Synchronizing grayed out

Having an issue where the start synchronizing menu item in the replication monitor is grayed out for users who have repl_monitor permissions in the distribution database. The weird thing is that it ...
1
vote
0answers
69 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 ...
0
votes
1answer
22 views

Database with many publication, How to make snapshots for publications run faster

I have a database that has about 200 filtered publications. When we run snapshots it drags down the merge processes and it takes a long time to recover because of the locks. Is there a way to create ...
1
vote
0answers
163 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 (...
1
vote
1answer
119 views

Merge Replication From Multiple Express to Central

So I am trying to setup a merge replication from multiple remote SQL 2016 Express installations to a central SQL 2016 Server. This would be for reporting purposes so I would need all the express ...
-1
votes
1answer
89 views

MySQL Replication Relay for Peer-to-peer replication for Multi-master replications [closed]

Any one knows about MySQL Replication Relay for Peer-to-Peer Replication for Multi-master replications? Please share if you know anything with example and syntax for multiple clients with as masters ...
1
vote
0answers
83 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. ...
3
votes
1answer
145 views

Strange UPDATE results in presence of merge replication

I have an MS Access front-end database that accesses an SQL Server backend. This (as far as we can tell) works flawlessly when the SQL Server database is not replicated. Once we introduce replication (...
1
vote
0answers
53 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 ...
0
votes
1answer
181 views

MsMerge_genhistory has alot of rows with pubid = null

I have a merge replication and I am worried that the cleanup of metadata might not be enough. I have a retention period of 60 days and I can see thet the metadatacleanup-job do remove rows i ...
2
votes
1answer
75 views

Replication recommendation

I am asked to investigate viability to use SQL Server replication technology for one of our upcoming project. In this project, basically there will be one central server located at corporate HQ (say ...
1
vote
1answer
140 views

Merge replication - corrupt row continually trying to INSERT

We have "push" SQL replication sent up, with one publisher and three subscribers. Two of the three are working fine, but one is continually causing trouble. I went through the pain and heartache of ...
1
vote
1answer
218 views

Merge Replication customize synchronization cycle and its performance

I'm trying to implement Merge Replication between just two servers, a publisher and one Subscriber. Assume these tables : --Main table in Publisher Ticket (id, userId, reqId, blockedDate, usedDate, ...
0
votes
2answers
4k views

MySQL merge two tables of different database to single database [closed]

Friends, i have database named as DB1 with a table called TB1A and another database as DB2 with a table TB2A. TB1A having 5 columns and TB2A having 8 columns, All the columns available in TB1A is ...
2
votes
1answer
221 views

Merge replication Identity columns for already existing databases

I'm attempting to setup merge replication with Pull subscriptions (SQL Server 2014 for Subscribers and 2016 for the Publisher). I have a number of databases at remote sites which operate independently,...
1
vote
0answers
260 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 ...
1
vote
1answer
40 views

SQL 2008 R2 Merge Replication - Clearing Skipped Schema Changes

A developer made a change to our production database that is using merge replication to a table (Activity). That table has a Foreign constraint that points to a table that is not part of replication ...
1
vote
1answer
489 views

SQL Server 2016 very slow snapshot generation

We've faced such a problem after migrating from SQL Server 2008 to SQL Server 2016: there's a merge replication implemented and it takes up to 2 hours (!) to generate a snapshot, instead of 5 minutes ...
0
votes
1answer
107 views

Two-way replication between SQL Server 2005 and SQL Server 2008

We currently have a SQL Server 2008 and SQL Server 2005 participating in one-way transactional replication of a single database. If possible we would like to set this up as a Two-way replication. ...
0
votes
1answer
87 views

Merge Replication: Service Account Password Change

Is it possible to change the password of a SQL Server service account that is used for not only on the publisher server but the 6 subscriber servers as well without seriously affecting merge ...
0
votes
1answer
300 views

Server and Client type Subscriptions

What is Server and Client type subscriptions in Merge Replication? How to select one of these during merge replication setup?
0
votes
1answer
201 views

SQL Server is unable to connect to server , requires the actual server name

I buy a cloud vps on vsp.ag , which is ubuntu os and I install sql server using this . I can remotely connect from my local PC using IP address of VPS . But I can't configure the distribution. It ...
4
votes
0answers
257 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. ...
1
vote
1answer
53 views

What does it mean when a merge replication generation has no changes?

According to MSDN, MSmerge_genhistory contains one row for each generation. A generation is a collection of changes that is delivered to a Publisher or Subscriber. Generations are closed each time ...
3
votes
1answer
895 views

SQL equivalent to CouchDB for 2 way replication

Are there any SQL server variants (i.e MySQL, Postgresql etc) that handle replication as well as couch db does and offers client side replication (2 way)? I'm in the early stages of my app which is ...
1
vote
0answers
216 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 ...
0
votes
1answer
73 views

SQL SERVER 2008 R2 Identity Range

The current table I am having issues with has an Publisher Range Size of 10,000, but when I look at the constraint I only see 1000 for the range size at the publisher. I have tried running ...
1
vote
0answers
224 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 ...
1
vote
0answers
40 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 ...
1
vote
1answer
76 views

SQL Server replication with subscriber doesn't know about the publisher

I have a case where many SQL Server instances need to be merged and centralized in one master database. This needs to be near real-time solution. After looking around in Google, I've found that ...
1
vote
1answer
170 views

How can I find out that a publication has “replicated schema changes” enabled?

Where can I find out (preferably using T-SQL) within a published databases, if it would replicate the schema changes? here is how to create a publication This topic describes how to create a ...
2
votes
0answers
176 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 ...
1
vote
0answers
353 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. ...