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.
213
questions
0
votes
0
answers
30
views
Error Trying to Replicate Database
I am getting the following errors in replication monitor when trying to do a Merge Replication between SQL in two locations
The subscription could not be initialized using an initial snapshot because ...
0
votes
1
answer
48
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 ...
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
93
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&...
0
votes
1
answer
160
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 ...
0
votes
0
answers
32
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 ...
0
votes
0
answers
95
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 ...
0
votes
0
answers
143
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 ...
1
vote
1
answer
197
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 ...
0
votes
1
answer
266
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 ...
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 ...
0
votes
0
answers
73
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 ...
0
votes
1
answer
162
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. ...
-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 ...
0
votes
0
answers
430
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, ...