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
19
votes
4 answers

A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active

I have 2 servers connected over a low speed wan and we're running SQL Server 2008 with Merge replication. At the subscriber, sometimes when attempting to insert new rows, I get this error: A trigger returned a resultset and/or was running with SET…
Sam
  • 759
  • 1
  • 4
  • 10
13
votes
2 answers

Set Identity_insert on - Merge Replication

I have merge replication set up between two databases and am using identity ranges on both. I want to add a specific row to a merged table (setting the identity value to something outside of the identity range) on the publisher. When I try this, I…
Paul McCann
  • 442
  • 5
  • 13
13
votes
4 answers

How to merge and synchronize SQL Server Database Files?

I'm building a C# program for windows tablets that are synchronized with a database. They will each have their own local .MDF SQL Server database which they interact with using SQL Server Express. However the users will take the tablets out of an…
Charles Clayton
  • 17,005
  • 11
  • 87
  • 120
10
votes
2 answers

Inserts in Merge Replication database are insanely slow

I have a SQL server that is setup with merge replication to 800 mobile clients running SQL CE. The server has enough resources and the lines in and out of the company are more than adequate, the replication between clients and the server is…
Gavin Mannion
  • 875
  • 1
  • 14
  • 32
10
votes
4 answers

SQL Azure Merge Replication

Does anyone know if SQL Azure supports merge replication? I am currently working with the web version of SQL 2008 R2 and it does not support the publication side of replication and I need a solution that will that doesn't cost $7000.
CoderMarkus
  • 1,118
  • 1
  • 10
  • 24
8
votes
4 answers

GUID of 00000000-0000-0000-0000-000000000000 causing merge index violation

Our developer has a linq-2-sql project that talks to my database. The database is involved in merge replication. It has been in use for some time and was working fine. A recent table was added to the schema and now is causing problems when new…
RThomas
  • 10,702
  • 2
  • 48
  • 61
7
votes
2 answers

Sync data from local db to Central SQL Server

I have a requirement to sync local db data with central SQL server. The remote users (mostly around 10 people) will be using laptop which will host application and local db. The internet connection is not 24x7. During no connectivity, the laptop…
ram
  • 71
  • 3
7
votes
2 answers

Changing column constraint null/not null = rowguid replication error

I have a database running under Sql server 2005 with merge replication. I want to change some of the FK columns to be 'not null' as they should always have a value. SQL server won't let me do that though, this is what it says: Unable to modify…
Dale
  • 12,884
  • 8
  • 53
  • 83
6
votes
2 answers

How to update conflict resolver when upgrading from SQL-Server 2005 to SQL-Server 2008

We have recently upgraded from SQL Server 2005 to SQL Server 2008 (R2, SP1). This upgrade included some publications, where all tables are published with a default conflict resolver based on the "later wins" principle. Its smart name is 'Microsoft…
Philippe Grondier
  • 10,900
  • 3
  • 33
  • 72
5
votes
1 answer

Future of "Logical Records" in SQL Merge Replication

I am building a new application which will be using SQL Merge Replication over very poor networks. It appears that the "Logical Records" feature would help significantly in coping with these network problems, ensuring that we can get complete…
Robert Levy
  • 28,747
  • 6
  • 62
  • 94
5
votes
1 answer

Is it possible to ignore NOT FOR REPLICATION in Visual Studio's Schema Compare?

I have two environments: dev and test. Dev has a single SQL instance. Test has three which use merge replication. When I use Schema Compare between dev and test, every table is always flagged as different because the tables in Test have a few…
Ivy
  • 887
  • 1
  • 7
  • 25
5
votes
2 answers

Sync nightmare - is it possible to use Merge Replication (or RDA) between 2 SQL CE instances without IIS?

We are faced with the following problem that involves keeping the following in sync: 1 Centralised Server (IIS / MSSQL 2005) Many Desktop WPF clients distributed by ClickOnce Many Mobile clients - (Windows CE) alt text…
chickeninabiscuit
  • 9,061
  • 12
  • 50
  • 56
4
votes
3 answers

Does changing fill factor on Identity column affect Merge Replication?

I have identified multiple Identity columns in a database that are set to 80 or 90%. I wish to set them all to 100%. Does anyone know if changing the fill factor on an identity column using Merge Replication causes any issues?
Jersey
  • 151
  • 1
  • 7
4
votes
2 answers

What's the solution for bidirectional Replication type on vertical filtered table(some of columns) in SQL Server 2008

Assume we have a table in two database instance like following: CREATE TABLE StudentList ( StudentId int NOT NULL PRIMARY KEY, StudentName nvarchar(255) NOT NULL, StudentGrade int ) We want to create a bidirectional replication…
Mohammad Sheykholeslam
  • 1,379
  • 5
  • 18
  • 35
3
votes
1 answer

SQL Server Replication : Removing broken subscriptions at the publisher

We have multiple subscriptions (merge pull) at our subscriber for only 1 "real" subscription. I think we actually broke it like this by adding and removing the subscription from the subscriber side, and then trying to replicate it... multiple…
Master Zang
  • 77
  • 2
  • 8
1
2 3
…
17 18