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
28 views
Infinite Loop in SQL Server Merge Replication When Using Delete + Insert for Detail Records
I have a typical master-detail table relationship (e.g., Orders and OrderDetails). My application updates the detail records by: Deleting all existing detail records for a given master record. ...
1 vote
0 answers
51 views
Merge replication is continually creating the same table on each sync
We create a new table in the Publication database and add a new Article to include that table in replication. We then create a new snapshot. The next sync will duly create that new table in the ...
- 11
0 votes
0 answers
30 views
merge replication - change the property pre_creation_command just for one article, is it possible?
merge replication publication - I would like to change the property only for this particular table myTable ,so that it will truncate the table at the subscriber, but I would like to leave all other ...
- 17.3k
0 votes
1 answer
131 views
where does sql server store replication monitor info?
it is not my way to check the replication, however, on this instance I have many publishers on my replication monitor, as you can see on the picture below: where does sql server store the publishers ...
- 17.3k
0 votes
1 answer
94 views
sql server merge replication - how to find out where the snapshot folder is what are the permissions for that folder
I am looking for the location of the snapshot folder for my merge replication I have tried: select top 5 * FROM sysmergepublications pub select * FROM dbo.sysmergeSubscriptions but that does not ...
- 17.3k
0 votes
1 answer
117 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 ...
- 17.3k
0 votes
0 answers
342 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
400 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
168 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
168 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
276 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
351 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
2k 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
85 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
225 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