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
2 answers

SQL2008 merge replication fails to update depdendent items when table is added

Setup: an existing SQL2008 merge replication scenario. A large server database, including views and stored procs, being replicated to client machines. What I'm doing: adding a new table to the database mark the new table for replication (using…
Dan Puzey
  • 33,626
  • 4
  • 73
  • 96
1
vote
1 answer

Merge two xml schemas using XSLT

I'm transforming an XML Schema using XSLT 2.0. The first schema (s1.xsd) imports a second schema (s2.xsd) as follows: Content of s1.xsd
conciliator
  • 6,078
  • 6
  • 41
  • 66
1
vote
1 answer

Merge Replication : Column 'rowguid' in table 'TableName' is invalid for creating a default constraint

I am using merge replication to synchronize data between two databases. It creates a new column in each article table 'rowguid'. At the time of sync, it is throwing error: Column 'rowguid' in table 'TableName' is invalid for creating a default…
Vijay
  • 2,965
  • 1
  • 15
  • 24
1
vote
1 answer

Will this force a reinitialize in Merge Replication Topology?

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint column or a part of any article filters and it allows NULL. I have a pretty good idea that I can run this: ALTER TABLE tblPlanDomain ADD…
Refracted Paladin
  • 12,096
  • 33
  • 123
  • 233
1
vote
1 answer

SQL Server Express 2005 Merge Replication using RMO causes Null Reference exception

I'm trying to use RMO to programmatically perform merge synchronization. I've basically copied the SQL Server example code, as follows: // Create a connection to the Subscriber. ServerConnection conn = new…
Craig Shearer
  • 14,222
  • 19
  • 64
  • 95
1
vote
2 answers

Pattern to load data to Elasticsearch from SQL server

Here is what we came up with. By using 3 value status column. 0 = Not indexed 1 = Updated 2 = Indexed There will be 2 jobs... Job 1 will select top X records where status = 0 and pop them into a queue like RabitMQ. Then a consumer will bulk insert…
user432024
  • 4,392
  • 8
  • 49
  • 85
1
vote
0 answers

How to update XML Schema Collection using SQL Server Merge Replication

I am testing using SQL Server 2014 to replicate (using Merge Replication) a database between two servers. I have already setup replication successfuly and I am now testing how to apply changes to the database. This database uses a few XML Schema…
lbarreira
  • 175
  • 10
1
vote
0 answers

SQL Server merge replication: ensure that all children in one to many relation are synced before parent is usable

I have this problem: two tables with one-to-many relationship between them. When they are synced between different instances of SQL Server, parent goes first, as all children have FK to it and depend on it being present, and after that children come…
Goran Obradovic
  • 8,951
  • 9
  • 50
  • 79
1
vote
1 answer

Long Running Merge

When I'm doing synchronization between database in different system, I'm getting the "long running merge" warning in the replication monitor. As my database consists of hundreds of thousands of records, so it is taking some time to execute which…
Developer404
  • 5,716
  • 16
  • 64
  • 102
1
vote
1 answer

How to generate database script without replication data in sql server 2008 R2

I have two server in two areas "WAN" : "distributed system". I applied a merge replication for these two servers (Microsoft Sql Server 2008 R2). Now I'd like to generate the database script "Schema and Data", without replication data informations…
user3472444
  • 13
  • 2
1
vote
1 answer

How to make SQL Server copy permissions for view in merge replication

I have a merge replication in my SQL Server 2008. I'm replicating some views, and I can't find an option to copy permissions for it, while tables, stored procedures and user-defined functions have this option. I see only "Copy extended properties"…
Saito
  • 694
  • 7
  • 25
1
vote
1 answer

Transactional publication with updatable subscriptions and Conflict Resolvers

I am able to find a great deal of documentation about creating custom conflict resolvers and using Managed code-based resolver as a business logic handler when replicating SQL Server using a "Merge publication" but can't seem to find anything about…
detroitpro
  • 3,853
  • 4
  • 35
  • 64
1
vote
1 answer

Restart Merge Replication After Failure

I would be surprised if this has not been answered before but I cannot seem to find the answer I am looking for. I am testing out the basic functionality of merge replication. Changes flow between the subscriber and publisher. One scenario I…
Jason Richmeier
  • 1,595
  • 3
  • 19
  • 38
1
vote
1 answer

How do you run SQL Server Merge Replication Jobs sequentially?

I work with an environment that uses Merge Replication to publish a dozen publications to 6 a dozen subscribers every 10 minutes. When certain jobs are running simultaneously, deadlocks and blocking is encountered and the replication process is not…
Chris Morgan
  • 115
  • 1
  • 12
1
vote
2 answers

SQL Server Simple Redundancy

I am quite a rookie here and would like to ask all you experts out here on the preferred method of configuring two SQL Servers (2008 R2 and above) for a simple redundancy with the following characteristics: There are 2 computers. Each will have its…
Jason
  • 15
  • 1
  • 6
1 2 3
…
17 18