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

Where can I see the @published_in_tran_pub property?

We have a merge replication that sources on a subscription of a transactional replication. According to this source (Multiple SQL replication types) I need to set the @published_in_tran_pub to true. So far so good, however now I would like to check…
user3248190
  • 101
  • 1
  • 10
0
votes
1 answer

Is a Transactional Replication Snapshot processed as a 'bulk insert'

I have a Merge replication that sources on a subscription from a Transactional Replication. I know that the triggers regarding the Merge replication are not fired by 'bulk inserts': Microsoft: When data is loaded into tables using the bcp Utility…
user3248190
  • 101
  • 1
  • 10
0
votes
1 answer

Why can't I connect to SQLCE/IIS web service when there is no network connection on the desktop?

I have a Windows CE 5 device that I connect through USB to a Desktop. On the desktop is the SQLCE replication(?) web service/dll (Merge Replication Agent). It's installed properly as far as I know-- the test on the desktop to…
Yves
  • 682
  • 1
  • 6
  • 15
0
votes
1 answer

Resolve Upload Insert Failed merge conflict

I have a series of rows created at the Subscriber that are not being replicated to the Publisher. The conflict viewer shows a Conflict Type of 5(Upload insert failed) with this error: A row insert at '{subscriber}' could not be propagated to…
Dave Zych
  • 21,581
  • 7
  • 51
  • 66
0
votes
0 answers

Replication Management Objects under SQL Server 2012

we are using SQL Server 2008 with merge replication. Our business application uses the rmo api, which we have installed with SQL Server Feature Pack 2008 SP3 and there the package sql_rmo.msi. Now we want use SQL Server 2012 or 2014. In SQL Server…
Jan Lorenz
  • 1
0
votes
1 answer

SQL replication, merge publication, cannot connect to subscriber

i have some difficulty in setting up SQL replication over the internet. I am using a static public IP thru my firewall and port forward to the distribution server. basically everything is fine, i was able to register and connect the remote…
jake
  • 167
  • 2
  • 14
0
votes
1 answer

"The column cannot be modified because it is an identity, rowversion or a system column" - but it isn't

I am getting this error: The column cannot be modified because it is an identity, rowversion or a system column. [Column name = BatchClosed] But [BatchClosed] is a nullable bit column and identity is false. I am using Sql Server Compact Edition…
Colin
  • 22,328
  • 17
  • 103
  • 197
0
votes
0 answers

How to troubleshoot "The statement failed to execute"

After losing a disc partition I have recovered our Sql Server database. The old database used merge replication to synchronise with mobile devices and I have been re-creating the replication. I can get a device to connect with the database but I get…
Colin
  • 22,328
  • 17
  • 103
  • 197
0
votes
1 answer

How to Disable Publishing And Distribution?

I'm getting the following error while disabling publishing and distribution. Plz, tell me how to do disable publishing and distribution? SQL Server could not disable publishing and distribution on 'server'. An exception occurred while…
Developer404
  • 5,716
  • 16
  • 64
  • 102
0
votes
1 answer

SQL Server Merge Replication Error - Could not Propagate to the subscriber

I am getting the below Error: I have a Publisher SQL Server 2012 on a remote VPS and a local subscriber running on a Parallel VM within Mac. The Agent at the Publisher has full access to the folder. But is still unable to create the publication…
izzymo
  • 916
  • 1
  • 10
  • 14
0
votes
2 answers

How to check if SQL Server 2008R2 merge pull subscription is set to reinitialize?

I am using RMO and some T-SQL to manage my subscriptions and have a need to know if a subscription has been set to reinitialize on next sync.
edeevans
  • 60
  • 6
0
votes
1 answer

SQL Replication Returns No Status

We are synchronizing SQL Server CE with SQL Server 2008 R2. There are two different publications we need to synchronize, and we call them each in sequence. This is a (greatly abbreviated) sample of what we are…
Brad
  • 1,357
  • 5
  • 33
  • 65
0
votes
1 answer

Possible to use SQL Server CE 3 (aka 2005 mobile edition) with merge replication to SQL Server 2008r2?

My client is retiring a server and wishes to move our application's data from SQL Server 2005 to SQL Server 2008r2. We use Merge Replication via IIS to synch the data to Windows Mobile 6.5 devices. The devices currently are running SQL Server CE3,…
Dave Welling
  • 1,678
  • 1
  • 17
  • 13
0
votes
1 answer

SQL Trigger that runs ONLY at Publisher

I have an in house app that has both a Web Interface and a Desktop Interface(is an OCA using Merge Replication). We are still using SQL 2005 and have many 'Archive' tables set up. These are filled by Triggers on there relating Table. …
Refracted Paladin
  • 12,096
  • 33
  • 123
  • 233
0
votes
1 answer

Resychronize merge replication

I have an issue where there was a merge replication between 2 instances for around 10 articles that has now been dropped. I want to recreate the merge replication - I am looking for inputs on the steps/ different options to set it up again and…
user3169222
  • 3
  • 1
1 2 3
…
17 18