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.
212
questions
0
votes
1
answer
28
views
snapshot to apply just the schema changes - not the data
I am restoring databases to each side of my transactional and merge replications.
Basically the publication and the subscriber are the same database initially.
I still need to run the snapshot agent ...
- 16.2k
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 ...
0
votes
0
answers
27
views
SQL Server Merge Replication - No subscription is on this publication or article
I have setup a merge replication publication and added a subscriber but when I view the synchronization status I just get the error message: "No subscription is on this publication or article&...
- 1
0
votes
1
answer
114
views
SQL Server Replication Licensing
Production database is hosted on a SQL Server Standard instance and is replicated using merge replication with web synchronization to 10 subscriber databases hosted on 10 separate SQL Express server ...
- 13
0
votes
0
answers
28
views
SQL Server Merge Replication using Web Synchronization - RESUMING SYNC
We are using MSSQL Merge Replication using Web Sync over extremely slow connection with many SQL Express subscribers.
For some reason, occasionally, connection is dropped and the subscriber is trying ...
- 13
0
votes
0
answers
73
views
Configure SQL Server merge replication in local machine and a server machines
I have two databases on my local machine and the server. I want to sync them whenever they are being changed. For my scenario I'm using SQL Server replication.
I use merge type to sync these databases ...
- 101
0
votes
0
answers
142
views
Replication in SQL Server by Merging a Publisher and Subscriber
I have 2 databases, A and B.
database A contains a subset of database B. I want to replicate any changes on database A (insert, update, delete one way replication) to database B without affecting any ...
- 111
1
vote
1
answer
177
views
Sync Common Data into Multiple MySQL Databases
My Situation
I have MySQL databases, each with the same schema (table structure and relationships exactly the same).
The data in the Green database is shared by the other three. I have a nightly ...
- 113
0
votes
1
answer
243
views
Restore SQL Server replication subscriber
We have merge replication in our system and there is a case when we need to deploy our system with subscriber database and time is crutial. I wonder if the is possibility to take configured subscriber ...
- 3
0
votes
0
answers
1k
views
The replication agent encountered a failure
I have created a new merge replication. I am facing this issue:
When I go to start the 'View Agent Snapshot Status', it shows an error:
I clicked start but still got the same error.
I have viewed at ...
- 101
0
votes
0
answers
69
views
SQL Server Replication - accidentally unselected table from snapshot: how do I add it back in again?
Using SQL Server merge replication, one of the tables was accidentally unselected (check box unticked). How do I add it back in to the snapshot again? It was unfortunately a large table with plenty ...
- 141
0
votes
1
answer
154
views
Merge Replication Subscriber does not Expire or cleaned up
I have a merge repliaction with retention period set to 1 day. Allow anonymous Subscriptions is set to False.
I Add 2 subscribers. One of the subscriber machine name is wrong, so it is inaccessible. ...
- 459
-1
votes
1
answer
7k
views
Update and migrate database from SQL Server 2014 to SQL Server 2019
I want to update and migrate database from SQL Server 2014 to SQL Server 2019 so that if there is any failure at SQL Server 2019 I will come back at SQL Server 2014 and get all the transactions back ...
- 1
0
votes
0
answers
409
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, ...
- 121
0
votes
1
answer
510
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 ...
- 23
0
votes
1
answer
94
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 ...
- 23
0
votes
1
answer
362
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).
...
- 498
0
votes
1
answer
41
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
1
vote
0
answers
332
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 ...
1
vote
1
answer
852
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 ...
- 15
2
votes
0
answers
355
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....
- 35
0
votes
1
answer
455
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....
- 135
0
votes
0
answers
93
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 ...
- 205
0
votes
1
answer
88
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 ...
- 263
0
votes
2
answers
338
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 ...
- 263
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: ...
- 135
0
votes
1
answer
1k
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 ...
1
vote
1
answer
1k
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 ...
- 263
0
votes
0
answers
60
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
1
answer
730
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 ...
- 309
2
votes
1
answer
813
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
-...
- 211
0
votes
1
answer
99
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
0
answers
232
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 ...
- 211
0
votes
1
answer
245
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 ...
- 101
1
vote
1
answer
147
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 ...
- 211
1
vote
1
answer
90
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 ...
- 135
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 ...
- 121
2
votes
1
answer
103
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 ...
- 23
2
votes
1
answer
61
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 ...
1
vote
0
answers
105
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 ...
- 66
0
votes
1
answer
39
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
1
vote
1
answer
433
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 (...
- 66
1
vote
1
answer
246
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 ...
- 43
-1
votes
1
answer
314
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 ...
- 99
2
votes
0
answers
256
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. ...
- 121
3
votes
1
answer
348
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 (...
- 256
1
vote
0
answers
85
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 ...
- 21
0
votes
1
answer
412
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 ...
- 21
2
votes
1
answer
108
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 ...
- 468
1
vote
1
answer
463
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 ...
- 303