Stack Overflow
Stack Overflow

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
1
vote
1 answer

Move schema changes and data from Publisher to subscriber in MergeReplication

I have a corporate server and around 50 remote clients. Images are added to Remoteclients and these Images are merge replicated to CorporateServer. Now initially all these images were on BLOB. We have decided to use filestream and create a new table…
Rohit Raghuvansi
  • 2,824
  • 8
  • 46
  • 74
1
vote
1 answer

My subscriber database lost connection to the publisher and expired. Can my data be saved?

I have a publisher database A and I have two subscriber databases B and C that subscribe to A. My application resides locally at sites B and C and through replication, changes at B and/or C are replicated to each other. The problem is since 31…
i_shoot_photos
  • 166
  • 2
  • 15
1
vote
0 answers

Merge replication with Filestream

I have the scenario where I am using a FILESTREAM enabled table to upload and download files from. I need the files available in two instances, database A and database B. Files can be uploaded to both A and B and must be synced to the other party.…
pgerchev
  • 177
  • 3
  • 13
1
vote
1 answer

SQL Server Msmerge_content

I just joined my new office as database administrator. Here we are using SQL Server merge replication. It surprises me that 3 of major replication tables Msmergre_contents Msmergre_genhistory Msmergre_tombstone Size of Msmergre_contents grew up…
Ahsan Mumtaz Abbasi
  • 53
  • 1
  • 11
1
vote
1 answer

SQL Server could not display the Schedule dialog box

I'm trying to establish a merge replication between SQL Server 2012 (SP2) servers. In the New Subscription Wizard, I want to setup the Agent Schedule and I have the following error when selecting "Define schedule..." Of course I have Googled the…
Dominic
  • 159
  • 1
  • 3
  • 13
1
vote
1 answer

Merge Replication fails to replicate UD type

I have a DB that includes some User Defined Types. As I understand, Merge Replication will automatically include the UD types that are been used. One of those types is a table variable witch is used in a function. And on publisher site works fine…
Manos
  • 77
  • 1
  • 10
1
vote
1 answer

merge replication sql server orphan constraints

We have recently migrated to a new server where first the database was restored and then the replication has been setup. The same Merge agent works with the existing server but not with the new one.Below is the error which pops up when the merge…
user8829086
  • 13
  • 3
1
vote
1 answer

Execute xp_cmdshell using C#

We have created a Windows Forms application to synchronize databases using merge publication and merge pull subscription. We have created publication and subscription successfully. Now We want to start synchronize data. For that we want to execute…
Dev
  • 62
  • 11
1
vote
1 answer

SQL Server Merge replication - Applying the snapshot to the Subscriber manually and not via GUI

I am having issues finding material on how to send a snapshot to a subscriber server to apply the snapshot at a later stage. My situation: Publisher is based in SA. Subscriber is based in Germany. To deliver a 8GB database snapshot takes almost a…
Jay
  • 51
  • 3
1
vote
1 answer

Merge Replication - Invalid Column Name

Good Day everyone, I am battling with a merge replication. I added a new column to an existing Merge Replication and Rerun the snapshot. This replicates to 3 different servers in different locations. 1 Replication works perfectly, but 2 of the…
Mardus Davel
  • 77
  • 8
1
vote
1 answer

The format of a message during Web synchronization was invalid. Ensure that replication components are properly configured at the Web server.

Getting the error "The format of a message during Web synchronization was invalid. Ensure that replication components are properly configured at the Web server" in SQL server 2012 using merge replication. We have tried changing the registry key…
Shivansh Rawat
  • 11
  • 3
1
vote
1 answer

CD-CM setup with merge replication

I am in the process of trying to make the publishing process quicker and simpler for one of our customers, on their sitecore based website. Through research I stumbled upon Merge Replication which might solve some of our issues, but it introduces…
Niclas Schumacher
  • 83
  • 2
  • 9
1
vote
1 answer

SQL Server : merge replication error

Can anyone please help me out to solve this error in SQL Server merge replication? The merge process could not replicate one or more INSERT statements to the 'Subscriber'. A stored procedure failed to execute. Troubleshoot by using SQL Profiler.…
Ahsan Mumtaz Abbasi
  • 53
  • 1
  • 11
1
vote
2 answers

Sync SQL Server 2014 and SQL Server 2014 Express database using stored procedure or C#

I have a C# Windows Forms application (writen in Visual Studio 2013) and I have the same database schema in both SQL Server (for master user) and in SQL Server Express (for clients). My database size is around 2 GB for each client. I want to…
Jaimesh
  • 841
  • 4
  • 25
  • 41
1
vote
0 answers

Unable to login in SQL Server 2008 R2 64 bit from SQL Server 2008 R2 32 bit

I have a Windows Server 64 bit and I installed SQL Server 2008 R2 on it. I'm intending to use this machine for data replication. So, I have clients with Windows 7 32 bit on which I have installed SQL Server 2008 R2. I want to create a publication…
Shark-Neil Felyx
  • 51
  • 7
1 2 3
…
17 18