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
2
votes
1 answer

The issue of sp_MScheckIsPubOfSub stored procedure

We have SQL Server 2008 R2 Merge replication set up. We have 20+ push subscriptions. Once in a while I get the following error message during the sync: Error messages: The merge process could not set the status of the subscription…
Adel Khayata
  • 2,717
  • 10
  • 28
  • 46
2
votes
1 answer

Merge Replication and the Performance Impact on the controller SQL server

A third party vender implemented a solution that makes use of merge replication on our main SQL server. This server also hosts our SAP B1 db. Since the implementation of the solution our users have been experiencing performance issues on SAP B1. Is…
user1662606
  • 21
  • 2
2
votes
0 answers

Microsoft Merge replication for Android and iOS

Microsoft Sync Toolkit is extensible by design and allows you to connect databases on Android and iOS clients to sync. Can you get Merge replication to work with iOS and Android?
Tyler
  • 19,113
  • 19
  • 94
  • 151
2
votes
1 answer

Merge replication commands being executed for a particular table

Is there a table where I can view the merge replication commands being executed for a particular table? Thank you
user142253
  • 494
  • 1
  • 6
  • 16
2
votes
2 answers

Delete a Push Subscription from Subscriber using T-SQL in Merge Replication

I have a Publisher server and Subscriber Server which are synchronized using Merge replication. When i using wizard to remove Replication a login window ask me to login on Subscriber Server and remove its subscription but when I using generated…
Mohammad Sheykholeslam
  • 1,379
  • 5
  • 18
  • 35
1
vote
2 answers

Filtered merge replication SQL Server 2008

I'm looking for advice on how to achieve a bi-directional replication which only replicates specific rows in SQL Server 2008. For example, I would like to replicate Table A between two databases (Europe & Asia). I would like the table to contain…
Mojo
  • 21
  • 3
1
vote
1 answer

SQL Server CE replication failure: Internal error: HTTP header information is either corrupted or missing in the transport message

I have set up SQL Server 2008 R2 on a Windows Server 2008 machine and have created a test database on it and a corresponding publication in order to use merge replication. I have set said publication to cater to SQL Server 2008 and SQL Server CE 3.1…
Manos Dilaverakis
  • 5,849
  • 4
  • 31
  • 57
1
vote
0 answers

Merge Replication Failed During Synchronization. After re-run the agent failed at with (Replication Agent FATAL ERROR and shutdown)

In our corporation we configure a merge replication (PULL) as below: Publisher : SQL Server 2008 R2 on Windows 2003 Server Subscriber: SQL Server 2008 R2 on Windows 2003 Server (This is a instance sql) We use scripts for Create/Change articles.…
b2never
  • 11
  • 2
1
vote
0 answers

Join filter between more than two tables

So, I have a scenario where I have an article that I want to be filtered based on two other articles in the publication. If I were to write this as T-SQL, it'd be: select t3.* from t3 inner join t2 on t3.t2_id = t2.t2_id inner join t1 on…
Ben Thul
  • 31,080
  • 4
  • 45
  • 68
1
vote
1 answer

SQL Replication from Win CE device to SQL Server 2008 R2

I have a Windows CE device that I'd like to replicate data to a SQL Server 2008 R2 database. I understand the basics of replication and I need to use MSDN's "Two-Server Topology". Where there is an IIS box and a separate SQL Server box. I have…
Blaze
  • 1,863
  • 7
  • 23
  • 40
1
vote
0 answers

SQL Triggers and Replication

We'd really appreciate some help here, we've been scratching our heads for most of the day. We have a MS-SQL database on 'Server A' which has a table, in that table there is a trigger. This trigger is for INSERT only and all it does is read the…
Oscar Cymru
  • 11
  • 2
1
vote
1 answer

Merge replication between Express and Enterprise editions of SQL Server

I have two SQL Server servers. 1st is an Enterprise edition and it is a local server 2nd is an Express edition and it is online Now, the 1st pushes transactional replication to the 2nd. My question: is it possible to do merge replication between…
SHADOW.NET
  • 555
  • 1
  • 5
  • 20
1
vote
0 answers

Doing Pouch/Couch Style synching with SQL databases

We need a replication/push mechanism compatible with SQL which functions like pouch/couch. Specifically, we need to store data in browser, or on a local device, duirng remote data acquisition. At the time of acquisition, connection to end point SQL…
SzS
  • 161
  • 1
  • 4
1
vote
1 answer

Occasionally connected application (SQL Server data synchronization)

There is a central server that is running SQL Server 2008 R2 and WinForms clients, which use SQL Server CE to cache data. Data can be changed on both the server and client side. Each user can only edit his own data and view some of the data of other…
Boris Mitchenko
  • 880
  • 9
  • 18
1
vote
1 answer

RFI: Moving from SQL Replication to MS Sync

We are looking at replacing SQL Replication with another technology, possible MS SYNC. We are synchronizing the data and schema for a large SAAS application between multiple data centers and require high availability, reliability and…
PortageMonkey
  • 2,675
  • 1
  • 27
  • 32
1 2 3
…
17 18