Skip to main content
Database Administrators

Questions tagged [merge-replication]

Ask Question

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
Newest Active Bountied Unanswered
0 votes
0 answers
27 views

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. ...
Filbert Umbawa's user avatar
  • 1
0 votes
0 answers
30 views

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 ...
Marcello Miorelli's user avatar
  • 17.3k
0 votes
1 answer
94 views

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 ...
Marcello Miorelli's user avatar
  • 17.3k
0 votes
0 answers
342 views

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&...
josh's user avatar
  • 1
0 votes
0 answers
167 views

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 ...
mohammad kamali's user avatar
  • 101
1 vote
1 answer
275 views

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 ...
Eric Farr's user avatar
  • 113
0 votes
0 answers
2k views

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 ...
Kepler452B's user avatar
  • 101
0 votes
1 answer
225 views

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. ...
Mp0int's user avatar
  • 459

15 30 50 per page
1
2 3 4 5
…
15