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.

Merge replication starts with a snapshot of the publication database objects and data. Subsequent data changes and schema modifications made at the Publisher and Subscribers are tracked with triggers. The Subscriber synchronizes with the Publisher when connected to the network and exchanges all rows that have changed between the Publisher and Subscriber since the last time synchronization occurred.

More information: Merge Replication.

264 questions
0
votes
0 answers

SqlServer >> View syncronization status

I have two sql servers with repl-merge replication, on the subscriber server in Local Subscription if I tried to view Syncronization status I got windows with last status message "The specific pull subscription is not configured with a…
0
votes
1 answer

SQL Server 2022 Replication RMO Syncing No Interface Supported

I'm trying to get SQL Server 2022 setup to use merge pull replication. Topography has the publisher/distributor on the same server, with a second server running IIS for clients to connect to. Client machines are running SQL Server 2022 Express. All…
Ben
  • 1
0
votes
0 answers

SQL Server 2014 : Merge replication and transactional on same database

We currently have merge replication setup between Server 1 and Server 2. Server 2 is in a different geographic location. The merge replication is there so that users in the same region as Server 2 hit the database on Server 2 and those closest to…
0
votes
0 answers

Merge replication failed due to views applied to subscriber before tables

I am using SQL Server 2016 for pull merge replication. It inclueds tables, views, procedureds and functions. For some databases the merge agent is tring to apply views to subscribers before the tables are in first sync, causing it to error. Any idea…
0
votes
0 answers

Merge replication with temporal table in SQL server 2019

I have a table with SYSTEM_VERSIONING=ON and trying to create Merge replication and facing issue. In Microsoft documentation it is mentioned as "Merge replication:Not supported for temporal…
0
votes
0 answers

What is the sys.sp_MSmakegeneration

We have set up a merge replication in SQL Server. One of our biggest deadlocks is this stored procedure up above that is run by subscribers. CREATE PROCEDURE sys.sp_MSmakegeneration @gencheck int = 0, @commongen bigint = NULL, …
porya ras
  • 458
  • 5
  • 15
0
votes
1 answer

"Agent History Clean Up: Distribution" and "Distribution Clean Up: Distribution" Missing when Creating Merge Replication Instance

I've noticed recently that my distribution db is massive, and while searching for solutions, I keep coming across articles mentioning that these 2 jobs should be running: "Agent History Clean Up: Distribution" and "Distribution Clean Up:…
0
votes
1 answer

Will changing a VARCHAR(MAX) column to a VARCHAR(500) invalidate a merge replication snapshot in SQL Server 2014?

We have a number of columns in a table that were created as VARCHAR(MAX) this seems to be causing performance issues with our merge replication. We don't need these to be VARCHAR(MAX) and would like to change them to VARCHAR(500). Will this…
pedrodg
  • 115
  • 2
  • 10
0
votes
0 answers

how to use int identity as guid for merge publication?

How do I set the nId column (from the example table creation code below) up as uniqueidentifier to prevent the merge publication wizard from creating an unneeded GUID column? I am trying to set up merge publication in SQL Server Management Studio…
ruttergod
  • 167
  • 9
0
votes
2 answers

Adding/modifying unique constraints on a replicated table

I have an existing table in a replicated environment, I know there are restriction on schema changes that can be done on this table. Can I do the following. Add a unique constrainst on publisher and will it replicate to subscribers? If there is an…
Silverlight Student
  • 3,968
  • 10
  • 37
  • 53
0
votes
0 answers

How to set up MySQL replication between two MySQL instances

I developed a Laravel application (using Mysql for my database locally and remotly) for a small business and they asked me to make the application usable even if there is no internet connection, so I don't know where to start, What should i do to…
0
votes
0 answers

Strange Error message when Synchronizing subscriber

We have a VB.NET windows client that uses a local install of SQL Server Express that is a subscriber to our main SQL Server. We are moving from SQL Server 2012 to SQL Server 2017 and the VB.NET code that synchronizes the client subscription to the…
Gallows
  • 1
  • 2
0
votes
0 answers

Unnecessary auto bulk updates occurs on daily basis at specific time are uploading from all subscribers SQL Server merge replication

I'm using SQL Server 2012 Merge replication in our environment. the problem is that for almost a month unnecessary auto bulk updates occurs on daily basis at specific time uploading from all subscribers. I have checked everything on my publisher and…
0
votes
1 answer

Will existing subscriptions still be able to sync to a publisher that has had an article added to it (Merge Rep)

I have to add a new table to the publisher database which will then be added to the subscribers. I have done some digging and to allow the table to be replicated I need to add it as an article for that publication. When I add the article through…
lardymonkey
  • 728
  • 1
  • 16
  • 34
0
votes
1 answer

Rename Subscription database in merge replication

I want to rename a subscription database in merge replication. All the subscriptions are synchronized properly. IS it possible to rename one of the subscription database?