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

Why should someone use Identity Range Management with SQL Server

When I began to work on replication a few years ago, I was convinced that Identity Range Management was only made available in recent SQL Servers for legacy purposes as, prior to SQL Server 2000, the GUID type field did not exist and most primary…
Philippe Grondier
  • 10,900
  • 3
  • 33
  • 72
3
votes
1 answer

Are good security practices and auto identity range mgmt mutually exclusive?

I'm trying to use Automatic Identity Range Management. However, the only way to ensure my users can INSERT records in tables with identity columns is to make them db_owner. Am I missing something? For full background please refer to my earlier…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
3
votes
1 answer

replication between two tables with different names and which have different column names. Is it possible to create such replication

I have a requirement where i have create replication between two tables with different names and which have different column names. Is it possible to create such replication. server A server B ---------- …
Raymond Morphy
  • 2,464
  • 9
  • 51
  • 93
3
votes
1 answer

Merge replication does not work with non-default conflict resolver

I have been evaluating merge replication, 'push' subscription on SQL Server 2014. If the default resolver is used (I refer to @article_resolver parameter of sp_addmergearticle), all seems to work as expected. However if I use "Microsoft SQL Server…
alexk
  • 143
  • 1
  • 11
3
votes
1 answer

Replicate a filtered subset of data: Merge or Transactional replication?

First of all thanks for reading. I need to replicate a subset of data that is based on a join filter; filter based on a join with an other table (Microsoft:"Using join filters, you can extend a row filter from one published table to another."). This…
user3248190
  • 101
  • 1
  • 10
3
votes
1 answer

Merge Replication not receiving updates via Transaction Replication when republishing

I'm trying to migrate from server Z, which replicates out to a dozen subscribers in two data center, to servers A & B, one in each data center. In order to survive outages between data centers we were looking at doing Merge Replication between A &…
mbourgon
  • 1,286
  • 2
  • 17
  • 35
3
votes
5 answers

How to check replication snapshot agent status?

I'd like to check the status of the agent after I start it using this statement EXEC sp_startpublication_snapshot @publication As I want to do a next step that needs the job to be already started.
Ahmed Fayed
  • 141
  • 2
  • 10
3
votes
1 answer

How to skip a schema change in Merge Replication

How can I skip a schema change in Merge Replication? I added a column to a table as not null, but subscribers first have to create the column with null data so its failing to replicate. I already changed this column in origin as null, but the agent…
E-Bat
  • 4,792
  • 1
  • 33
  • 58
3
votes
0 answers

"Subscription to Publication" Verified

I'm using SQL Server 2008 R2 on a server, with SQL Server 2008 R2 Express on about 40 mobile devices. Merge replication is set up with 1 publisher & distributor server, with the mobile devices as subscribers. I've hit a stone wall trying to…
Michael Parkinson
  • 31
  • 2
2
votes
1 answer

ALTER a replicated column in SQL Server 2008 R2. Merge Replication

I want to alter columns in StudentPerformance table Columns to be altered are - StudentName varchar(50) to StudentName varchar(100) Percentage decimal(18,0) to Percentage decimal(18,2) It is configured for merge replication. Will it make my…
Thakur
  • 1,890
  • 5
  • 23
  • 33
2
votes
2 answers

SQL Server Merge Replication fails with "Initializing SQL Server Reconciler has failed. Try again."

I'm trying to set up replication between a SQL Server 2008 R2 database and SQL Server CE 3.5. I have set up IIS 7 accordingly and get a nice "Microsoft SQL Server Compact Server Agent" when checking the publication URL…
Manos Dilaverakis
  • 5,849
  • 4
  • 31
  • 57
2
votes
1 answer

VS 2010 database deployment for replicated tables

I started to use the database projects that are in Visual Studio to start keeping better track of schema and stored procedure changes. I love the idea of it, but I have hit a little bit of a hiccup. In development, the tables in my database are not…
Justin Rassier
  • 898
  • 12
  • 26
2
votes
1 answer

Manual synchronization SQL Server enigma

I've installed two SQL Server 2008 in two sites linked by internet connection and I've installed a merge replication between them, but one of the sites got a long disconnection time and the customer asked us for a manual synchronization (file-based)…
HichemSeeSharp
  • 3,240
  • 2
  • 22
  • 44
2
votes
2 answers

SQL Server Performance Suggestion

I have been creating database tables using only a primary key of the datatype int and I have always had great performance but need to setup merge replication with updatable subscribers. The tables use a typical primary key, data type int, and…
Phxmobdev Developer
  • 23
  • 1
  • 5
2
votes
1 answer

Where Merge Replication actually stores data?

I've read some non-official articles that say merge replication actually stores data as transactions and replicate them as transactions. But no official info about that on MSDN or any kind of official sources I could reach. Please, can someone make…
Sergey Lobanov
  • 365
  • 3
  • 14
1
2
3
…
17 18