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.

Filter by
Sorted by
Tagged with
4
votes
1answer
92 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 ...
0
votes
0answers
24 views

Merge replication between PostgreSQL <-> SQLite

In my app, the database (Postgres) consists of various tables referencing each other in one-to-many and many-to-many relationships, organized in subtrees. Each data subtree has a single parent row at ...
3
votes
0answers
441 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 ...
2
votes
1answer
218 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 ...
0
votes
0answers
14 views

MS SQL replication table change causes failed drop/create due to constraints

I have a simple SQL server 2016 merge replication with one publisher and one subscriber. I changed a replicated table and followed the custom instruction of removing the table from the replication, ...
0
votes
1answer
30 views

SQL Merge Replication Issue - problem where backup and maintenance job which is running till morning and most of the server jobs are stuck

We have a merge replication environment which includes Publisher: Server1 where only one database of 125 GB in replication and also Distributor is also configured on same server hosted in a HyperV ...
3
votes
2answers
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 ...
0
votes
1answer
54 views

How do I get article properties from query in a merge replication

I would like to know if there are any queries to get article properties in a SQL Server merge replication. I'm able to get properties only by GUI. I select a publication properties then I get the page ...
0
votes
1answer
137 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 ...
0
votes
0answers
54 views

SQL Server Merge Replication Error: The merge process could not replicate one or more INSERT statements to the 'Subscriber'

I have a merge replication with a push subscription from the publisher. It is getting error and stopped synchronization. The synchronization started again automatically and get the same error. Data ...
0
votes
0answers
8 views

How to check Data replicated time on subscriber server in merge replication?

I have 10 servers and all are in merge replication. when i insert data in one of all then data replicated on all servers after some time. i just want to know the time when data is replicated on any ...
1
vote
0answers
69 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 ...
2
votes
1answer
99 views

Replication recommendation [closed]

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 ...
0
votes
0answers
27 views

Conflict Viewer in merge replication

i created merge replication on sql server 2014 Enterprise edition and i saw some conflicts in conflict table but when i opne conflict viewer it showing below Error before this it is working fine and ...
0
votes
1answer
437 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 ...
8
votes
2answers
8k views

SQL Server distribution database log file grows uncontrollably after full database backup

We have a merge replication environment that is pushing to 8 subscribers. This is working fine. Our distribution database is setup in Simple recovery mode. We have a maintenance plan that will backup ...
5
votes
1answer
4k views

Very slow merge replication synchronization

I had an unforeseen issue with a sub going down (generic error, was probably a connection issue) and now that I've reconnected the sub it is insanely slow re-syncing. It seems to download about 1000 ...
0
votes
0answers
15 views

Merge Replication not deleting unmatched filter rows from Subscriber Database

I have applied filters on articles in SQL Merge Replication and syncing the data using MergeSynchronizationAgent via Web Synchronization. The data is syncing as per the applied filters from publisher ...
3
votes
1answer
3k views

Merge reports 'You must rerun snapshot because current snapshot files are obsolete', gets caught in Death Loop

We have a very large Merge publication for a data warehouse with some large (.bcp files on the order of 20GB) fact tables that is causing us tremendous trouble. Specifically, we created a publication ...
0
votes
0answers
20 views

Creating subscriber for replication without initialization?

Just wondering - I am sitting here for past 30 minutes waiting for Subscriber to finish initialization for Merge Replication. Could I skip this step somehow? and skip snapshot creation? I have: ...
11
votes
1answer
2k views

Estimated versus actual query plan with function calls

I have this query on SQL server, a merge replication query: SELECT DISTINCT b.tablenick, b.rowguid, c.generation, sys.fn_MSgeneration_downloadonly ( c.generation, ...
0
votes
1answer
131 views

MS SQL Server Error: Replication components are not installed on this server on Ubuntu

We have a Windows 10 SQL Server 2014 Standard License I'm using on our local computer. Trying to replicate a database to an Ubuntu Server 18.x with SQL Server 2018 (installed using this easy guide). ...
4
votes
1answer
252 views

How does SQL Server Merge Replication maintain referential integrity?

Note: This is a curiosity question about SQL Server. I've been reading about SQL Server's Merge Replication feature, and there's one thing I just don't understand about it: How does Replication ...
0
votes
1answer
25 views

Transaction publication with merge publication

I have a transaction publication setup on SQL Server 2014 lets call it (node A) that replicates to SQL Server 2008 (node B), then I use merge replication to synchronize changes from (A) through (B) to ...
1
vote
1answer
308 views

Selecting specific table for each subscriber when using merge replication in SQL Server with multiple subscribers

I am using merge replication with SQL Server 2017. I have one publisher, and two subscribers (all in all 3 database servers). I need to replicate different tables to each subscriber. Is this ...
2
votes
0answers
111 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....
2
votes
3answers
551 views

SQL Server 2005 merge replication failure

We have a customer who, when trying to sync a client (subscriber) to the server (publisher,) receives the following error: 2012-11-30 21:03:33.334 Percent Complete: 18 2012-11-30 21:03:33.334 Data ...
0
votes
1answer
125 views

Why merge replication wants to replicate view before replicating related table?

We have a publication and a subscriber running on 2 SQL 2016 servers. Now the error that we are receiving during subscription initialization is: Error messages: The schema script 'vw_BlackList_961....
0
votes
0answers
69 views

Data integrity in one-to-many distributed architecture

We are a retail shop that has a central data repository which collects data continuously from geographically distributed 1500 odd servers (each store has one SQL Server instance). Like a one to many ...
0
votes
1answer
38 views

SQL Server replication: can I modify contents of a snapshot?

I have a merge replication which I was unfortunate enough to start modifying, in a way that required the subscriptions to get re-initialized. It makes very good sense and all, since I was touching ...
2
votes
1answer
346 views

How to manually invalidate a pull merge replication snapshot from the publisher

XY Problem background info: I have a pull replication publisher in which I want to add or alter a index and have those changes be applied to the subscriber. The solution to that problem I would like ...
0
votes
1answer
323 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 ...
0
votes
2answers
163 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 ...
1
vote
0answers
47 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
524 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. Error ...
0
votes
0answers
41 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
263 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
428 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
63 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
125 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 ...
2
votes
1answer
1k views

Inserts/updates are extremely slow with Merge Replication in SQL Server 2008

I got hired into a new company and they had merge replication already in place. They have had issues with it to the point I have to evaluate whether to keep it or replace it. The main issue is it ...
1
vote
1answer
73 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 ...
8
votes
3answers
1k views

High tempdb disk I/O during merge replication of BLOBs

Having a merge publication for replicating BLOBs (type image), got very high tempdb disk I/O for my size of data. Publication is download-only and has no filters. High disk I/O is caused by ...
1
vote
1answer
19 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 ...
10
votes
3answers
2k views

Hard limitation for merge replication article count?

A bit of background. We developed an app that uses merge replication. Right now, we are currently publishing about 212 articles, and everything is fine, as it appears to fall into the 256 article ...
2
votes
0answers
74 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
53 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 ...
4
votes
1answer
209 views

Merge replication with PDAs AND P2P replication between servers?

We're currently building a setup to scan tickets at an event. We plan on having 2 servers at each entrance but can't have a local link between the two. We have scanners (sqlCE) and half of them are ...
2
votes
1answer
43 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 ...
2
votes
1answer
1k views

SQL Server replication - set PollingInterval in sp_addmergepushsubscription_agent

I am trying to create replication subscriptions to and SQL Server 2008 R2 via a script. There are 3 subscribers so this script creates the subscriptions by calling sp_addmergesubscription and then ...

1
2 3 4 5