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.

learn more… | top users | synonyms

1
vote
0answers
488 views

Merge Replication Update Statement Timeout

I work for a company that provides web based data collection. Currently we have a SQL Server 2012 server as the publisher for 2 subscribers (planning on expanding up to 5+ subscribers), both SQL 2012 ...
0
votes
2answers
346 views

“an agent job has not been created for this subscription”

I have set up merge replication with a publisher on my SQL Server 2008 R2 box with the distributor on this box too; in Express I have created a subscriber but the subscriber won't run because of the ...
6
votes
1answer
1k views

Replicated Database Log File Maintenance

I have a database on the publisher that is involved in replication (publication configured for merge and transaction). Trying to regain control of the log file for this particular database (VLF count, ...
2
votes
1answer
205 views

Import issue with Replication

When I import some data from excel file to a table that is part of a merge replication, the data is imported successfully to the table, but those new records are not synced to subscribers that belong ...
1
vote
1answer
325 views

How to edit publication's generation_leveling_threshold configuration value

I dont know where I put this code: update sysmergepublications set [generation_leveling_threshold] = 0 I only need do it. But I need edited any funcion of agent.
4
votes
0answers
210 views

How to properly troubleshoot Merge Replication False Conflicts

We have SQL Server 2008 R2 Merge Replication setup. Lately I started getting conflicts for some tables, and when I check the conflict viewer, I can see that the winner & the loser column values ...
1
vote
0answers
358 views

How to delete orphaned records from sysmergesubscriptions table?

I have some old orphaned records for old subscriptions that I want to delete from the sysmergesubscriptions table. Each time I delete unnecessary records, it show up again after it syncs with any ...
1
vote
2answers
3k views

How to properly clean Merge Replication Setup

What is the proper way to completely clean Merge Replication setup ? I have tried to delete the subscriptions, then delete the publication then "Disable Publishing & Distribution" & delete ...
5
votes
2answers
685 views

SQL Server Replication Alternative Software

We have used SQL Server Replication for a long time and had some issues with it that sometimes we needed to reinitialize subscriptions to fix some issues & other times we needed to destroy the ...
0
votes
1answer
69 views

Merge subscription behaviour

I have a merge subscription with the ExchangeType parameter set to 1 (upload only). Rows are transferred to the publisher as expected. If I delete a row at the subscriber, the corresponding row at ...
6
votes
3answers
1k views

PK as ROWGUIDCOL or use a separate rowguid column?

There's a long-winded debate going on here so I'd like to hear other opinions. I have many tables with uniqueidentifier clustered PK. Whether this is a good idea is out of scope here (and it's not ...
4
votes
2answers
2k views

SQL Server Replication: “ALTER TABLE ALTER COLUMN” is not propagated to subscribers

We are running SQL Server 2008 R2 SP1 as publisher & distributor, and SQL Server 2005 SP3 as subscriber. The replication of schema changes is activated, and the replication has been running for ...
2
votes
2answers
123 views

Querying number of subscription to each publication

We have a production box that has about 60 publications on it. Some of these are used, and some seem to not be... What I need to do is create, or find, a script that will get the count of ...
1
vote
1answer
337 views

Syncronize mysql databases between local and hosted servers automatically

We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging ...
3
votes
0answers
161 views

merge replication too big

I have multiple handhelds which sync their data via merge replication. from time to time, new core data is imported on the server-database. for some reasons I keep the old data in the databse and set ...
4
votes
1answer
154 views

How to reinsert corrected rows from the conflict table?

I have a bidirectional merge replication. I had failure constraints because the primary key was just integer. I change the primary key to the old primary key + a location identifier.The problem is how ...
0
votes
1answer
134 views

Advise On SQL Server Data Replication

We have a huge enterprise system, with geographically seperated SQL servers. We have some requirements related with data replication between these servers. We have considered the Sync Framework ...
1
vote
1answer
242 views

SQL Server replication conflicts after migration from 2000 to 2008

I got a suggestion over at Stackoverflow to post here....greatful for any and all help. Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
0
votes
3answers
1k views

Merge Replication identity field issues

One of our clients is using our software with merge replication of a database on a SQL Server 2008 R2 machine. There are two production environments in separate geographical locations only one of ...
5
votes
3answers
2k views

What type of SQL Server Replication fits our scenario? Merge or Transactional?

Background In our current setup, we have a single SQL Server 2005 instance on our remotely hosted web server. We additionally have another (non-MSSQL) database which we use for our POS system, which ...
3
votes
1answer
107 views

How can we achive the replica of databases for SQL Server?

I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server. In the ...
3
votes
1answer
478 views

SQL Merge Replication: Cannot resolve conflict

I have a SQL Merge Replication over HTTP (Replisapi.dll). I'm not very familiar with the internas of the replication conflict solving because it was always working so far. Now I have two conflicts in ...
1
vote
1answer
240 views

Minimising downtime implementing merge replication on live system

Background We have three Servers running SQL Server 2008 which all contain a Product database. These are currently kept in sync once per day by sending a copy of the MDF to the two Subscribing ...
0
votes
1answer
272 views

SQL Server merge replication across domains

I'm getting the following message when trying to set up merge replication on SQL Server 2008 R2: The Merge Agent failed to locate the partitioned snapshot for this subscription in the expected ...
7
votes
1answer
3k views

SQL Server distribution database log file grows uncontrollably after full database backup

We have a merge replication environment that is pushing to 8 subscribers. This is working fine. Our distribution database is setup in Simple recovery mode. We have a maintenance plan that will backup ...
1
vote
1answer
593 views

How to troubleshoot SQL Server Merge Replication Conflict?

I have SQL Server 2008 R2 Merge Replication setup. I have 2 publications for the same database with 20+ subscribers. The logic of our application prevents changing the same data from 2 subscribers ...
3
votes
1answer
254 views

How to replicate from SQL Server 2000 to SQL Server 2008 R2?

I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber. I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine. Primary key fields are not ...
3
votes
1answer
517 views

The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber.

When syncing a SQL Server 2008 subscriber with a publisher, the sync fails at around 98% with this error message: The Merge Agent failed because the schema of the article at the Publisher does not ...
2
votes
2answers
1k views

Oneway sync of two SQL Servers via FTP

I need to replicate data from a ‘master’ SQL Server out to a number of replicas. Luckily the data only flows from the ‘master’ to the replicas. I need to replicate both schema and data. Data size ...
9
votes
1answer
5k views

Upgrade SQL Server 2005 to SQL Server 2012

I have a test environment set up with the following: Virtual Machine (Hyper-V) Windows Server 2008 R2 SP1(x64-bit) Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name) 1 ...
2
votes
1answer
873 views

Merge replication SQL Server 2008 publisher with SQL Server 2012 subscriber

is this somehow possible to have SQL Server 2008 publisher with a SQL Server 2012 subscriber for merge replication?
1
vote
1answer
331 views

SQL Server 2005 merge replication failure

We have a customer who, when trying to sync a client (subscriber) to the server (publisher,) receives the following error: 2012-11-30 21:03:33.334 Percent Complete: 18 2012-11-30 21:03:33.334 Data ...
3
votes
0answers
348 views

Uninitialized Merge replication subscription

I have 3 separate SQL Server 2012 databases running on 3 VM's. I have successfully configured one pull subscription to the distributor but when I add a 2nd subscription on another SQL Server the ...
6
votes
1answer
812 views

Estimated versus actual query plan with function calls

I have this query on SQL server, a merge replication query: SELECT DISTINCT b.tablenick, b.rowguid, c.generation, sys.fn_MSgeneration_downloadonly ( c.generation, ...
1
vote
0answers
59 views

How To Use Publication Without Precompiled Partitions

I am using SQL 2012 with merge replication. Our setup is quite complicated and thus it seems running the publication with precompiled partitions is not going to work. The merge agent is slow to do ...
3
votes
0answers
117 views

How To Diagnose Slow sp_mssetupbelongs

I am using merge replication with SQL 2012. When performing a clean sync using the merge agent I am getting a timeout on this stored procedure, sp_mssetupbelongs I am wondering what the best way to ...
5
votes
2answers
415 views

Why Do Replication Deletes Require sysadmin Access

I am running merge replication with SQL 2012. There seems to be a nasty consequence of the delete triggers added for replication in SQL 2012. Inside the delete triggers are this, select @xe_message ...
2
votes
0answers
101 views

MSMerge_contents Table Populated After One Sync

I am running merge replication with SQL 2012. When I first create my publication the MSMerge_contents table is populated with a large number of records with the colv1 being set to 0xFF. When I run ...
0
votes
1answer
429 views

Does The Stored Procedure sp_removedbreplication Remove Rowguids

In merge replication if I run sp_removedbreplication will that remove rowguids or not? Will it take into account the preserve_rowguidcol values in the sysmergearticles table?
1
vote
1answer
368 views

Locking And Blocking With Merge Replication

I am using merge replication in SQL 2012 with web sync. When I insert records into the top tables in my filter hierarchy it causes a lot of locking on the tables, including the merge replication ...
5
votes
1answer
586 views

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 ...
1
vote
1answer
56 views

Merge Replicate, reinitialise with a different part of the data

I have a set of database with merge replicate configured between them. The publisher is an aggregate of three sets of data. Call them set 0, 1, and 2 There are subscribers that grab one set of the ...
1
vote
0answers
54 views

Merge Replication Finding Session Id

I am using merge replication with SQL 2012. I am writing a custom business logic handler, and would like to know if there is a way to get a session id? For instance if the custom business logic ...
0
votes
1answer
229 views

How to understand what Columns Have Changed in Merge Replication

I am using merge replication in SQL 2012. Some of my merge articles use column level tracking. I am trying to understand how to use the 'lineage', and 'colv1' fields in the MSmerge_contents table to ...
2
votes
3answers
2k views

Table with identity column in merge replication

I have a table in SQL Server 2005 and I have an IDENTITY(1,1) property set for an ID column. Records are inserted in a table at a local server as well as a remote server. I am using Merge ...
1
vote
1answer
296 views

How Can I Isolate A Merge Replication Timeout

I am using merge replication in SQL 2012 with web sync. When I create my subscription I am getting a timeout. The error message is not clear about cause of the timeout, but what I do know is if I ...
2
votes
0answers
104 views

Identifying connection and publisher vs subscriber in merge replication scheme

We have an app that uses a central SQL Server 2008 database for folks here in the building on the domain. For teams out in the field - they connect to a local version of SQL Express while offline and ...
2
votes
1answer
207 views

How can I modify a trigger at subscribers SQL Server 2005?

I have a SQL Server 2005 publisher with SQL Server 2005 subscribers and one SQL Server 2000 subscriber running merge replication. Is there any way to modify triggers at a subscriber with the ...
2
votes
2answers
796 views

What is the Maximum Merge Articles in Merge Replication [duplicate]

Possible Duplicate: Hard limitation for merge replication article count? I am using merge replication in SQL 2012. I am looking here: Maximum Capacity Specifications for SQL Server (2012) ...
4
votes
1answer
122 views

Multiple Merge Replications on same SQL Server Database Conflicts

I have 2 separate merge replications on the same database on a server, one named 'POC' with a single subscriber running continuously, and another named 'Clubs' with ~50 subscribers. As of recently, ...