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.

Filter by
Sorted by
Tagged with
4
votes
1answer
1k views

Any reason not to add 'rowversion' column?

The TechNet article, "Optimizing Microsoft Office Access Applications Linked to SQL Server", recommends adding a rowversion column to SQL Server tables linked from MS Access. From the Supporting ...
1
vote
1answer
1k views

Mysterious merge replication problems creating a subscription

We have a merge publication which had been mostly working OK for a long time (years). Recently an article was added, we were informed the snapshot was out of date, so we regenerated it. Then we got ...
-1
votes
1answer
115 views

MySQL Replication Relay for Peer-to-peer replication for Multi-master replications [closed]

Any one knows about MySQL Replication Relay for Peer-to-Peer Replication for Multi-master replications? Please share if you know anything with example and syntax for multiple clients with as masters ...
4
votes
1answer
72 views

Merge Replication: Updates to Schema

We have a main SQL Server which replicates to two backup servers via continuous merge replication. There are regular updates to the schema. Regular changes include: Adding new tables and ...
3
votes
1answer
195 views

Strange UPDATE results in presence of merge replication

I have an MS Access front-end database that accesses an SQL Server backend. This (as far as we can tell) works flawlessly when the SQL Server database is not replicated. Once we introduce replication (...
1
vote
0answers
119 views

MS SQL Server merge replication cannot find file specified

I'm trying to setup merge replication between two MS SQL Server 2012 databases on different hosts in one domain. When replication is set up and first snapshot is generated replications starts. ...
1
vote
0answers
58 views

Anonymous subscribers does not get expired in merge replication

I have a Merge replication with anonymous subscribers, in my sysmergesubscriptions there are old subscriptions that still has the status 1 (active) and the last_sync_date is way below the ...
1
vote
1answer
182 views

Merge replication - corrupt row continually trying to INSERT

We have "push" SQL replication sent up, with one publisher and three subscribers. Two of the three are working fine, but one is continually causing trouble. I went through the pain and heartache of ...
1
vote
1answer
238 views

Merge Replication customize synchronization cycle and its performance

I'm trying to implement Merge Replication between just two servers, a publisher and one Subscriber. Assume these tables : --Main table in Publisher Ticket (id, userId, reqId, blockedDate, usedDate, ...
0
votes
2answers
5k views

MySQL merge two tables of different database to single database [closed]

Friends, i have database named as DB1 with a table called TB1A and another database as DB2 with a table TB2A. TB1A having 5 columns and TB2A having 8 columns, All the columns available in TB1A is ...
2
votes
1answer
599 views

federated tables? synchronization? replication? [mysql]

I have a REMOTE suppliers' table with, let's say, a code and a name, and several client databases will be creating new suppliers. Server database code | name ------+------- 1 | Mark 2 | ...
2
votes
1answer
273 views

Merge replication Identity columns for already existing databases

I'm attempting to setup merge replication with Pull subscriptions (SQL Server 2014 for Subscribers and 2016 for the Publisher). I have a number of databases at remote sites which operate independently,...
1
vote
0answers
295 views

Merge replication Problem

I have got some problem to implement Merge Replication in SQL server 2008 R2 which send me the error response at the time of Synchronization using PULL from Publisher. I have tried to solve the ...
12
votes
3answers
16k views

Replication Monitor Information using T-SQL

The image below shows a transaction replication problem that I am currently investigating. The image comes from the Replication Monitor. How can I get this information using T-SQL?
1
vote
1answer
41 views

SQL 2008 R2 Merge Replication - Clearing Skipped Schema Changes

A developer made a change to our production database that is using merge replication to a table (Activity). That table has a Foreign constraint that points to a table that is not part of replication ...
4
votes
0answers
267 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 various reasons I keep the old data in the databse and ...
3
votes
1answer
3k views

Merge reports 'You must rerun snapshot because current snapshot files are obsolete', gets caught in Death Loop

We have a very large Merge publication for a data warehouse with some large (.bcp files on the order of 20GB) fact tables that is causing us tremendous trouble. Specifically, we created a publication ...
0
votes
1answer
78 views

SQL SERVER 2008 R2 Identity Range

The current table I am having issues with has an Publisher Range Size of 10,000, but when I look at the constraint I only see 1000 for the range size at the publisher. I have tried running ...
1
vote
0answers
405 views

SQL Server 2008 R2 sp_replmonitorrefreshjob Issues

My team just moved our production SQL Server VM from one machine to another. During the move we also applied server updates. After the move was completed, everything tested as a successful move. ...
0
votes
1answer
112 views

Two-way replication between SQL Server 2005 and SQL Server 2008

We currently have a SQL Server 2008 and SQL Server 2005 participating in one-way transactional replication of a single database. If possible we would like to set this up as a Two-way replication. ...
0
votes
1answer
97 views

Merge Replication: Service Account Password Change

Is it possible to change the password of a SQL Server service account that is used for not only on the publisher server but the 6 subscriber servers as well without seriously affecting merge ...
1
vote
1answer
341 views

Server and Client type Subscriptions

What is Server and Client type subscriptions in Merge Replication? How to select one of these during merge replication setup?
0
votes
1answer
220 views

SQL Server is unable to connect to server , requires the actual server name

I buy a cloud vps on vsp.ag , which is ubuntu os and I install sql server using this . I can remotely connect from my local PC using IP address of VPS . But I can't configure the distribution. It ...
4
votes
0answers
316 views

Merge replication subscriptions are repeating the same actions endlessly

We have a merge publication set up on SQL Server 2008R2, with several subscribers. Synchronisation is done through the internet. Over the last few days, some subscribers are unable to synchronise. ...
1
vote
1answer
61 views

What does it mean when a merge replication generation has no changes?

According to MSDN, MSmerge_genhistory contains one row for each generation. A generation is a collection of changes that is delivered to a Publisher or Subscriber. Generations are closed each time ...
3
votes
1answer
1k views

SQL equivalent to CouchDB for 2 way replication

Are there any SQL server variants (i.e MySQL, Postgresql etc) that handle replication as well as couch db does and offers client side replication (2 way)? I'm in the early stages of my app which is ...
1
vote
0answers
237 views

High CPU usage occurs periodically on the subscriber

I have set up a merge publication and a subscriber with push subscription mode. On the subscriber, I notice the CPU usage is going high periodically. It may take about 40 seconds for the CPU Usage ...
1
vote
0answers
251 views

Merge Replication - set up new subscriber based on backup of publisher and last snapshot (object definitions only)

I have a replication setup with 1 publisher and 3 push subscribers. I need to add a new push subscriber. I cannot afford downtime for the publisher and the existing subscribers. My plan is to do the ...
1
vote
1answer
101 views

SQL Server replication with subscriber doesn't know about the publisher

I have a case where many SQL Server instances need to be merged and centralized in one master database. This needs to be near real-time solution. After looking around in Google, I've found that ...
1
vote
0answers
40 views

Database Replication or Single Point?

We have a Database and web application hosted in our office in Middle East, and we have 2 more sites in Philippines and USA. Both offices in Philippines and USA are using the same hosted Web ...
1
vote
1answer
221 views

How can I find out that a publication has “replicated schema changes” enabled?

Where can I find out (preferably using T-SQL) within a published databases, if it would replicate the schema changes? here is how to create a publication This topic describes how to create a ...
2
votes
0answers
218 views

SQL SERVER 2008 R2 - Merge Replication - Identity Seed issue

The server I am running has identity Management set to automatic for most of the tables I am replicating (A hand full have been set to manual). When the replication goes to change the range it ...
1
vote
2answers
96 views

2 Identical Servers/SQL Servers Processing Transactions w/ Merge Replication

Edited entire question for clarity. Scenario: Have 2 identical SQL Servers on separate servers, processing transactions from different applications simultaneously while being completely synchronized (...
2
votes
0answers
75 views

How to prioritise delete and update based on timestamp during replication?

We have two MS SQL Server 2012 servers running merge replication. We have used the SQL Server DATETIME (Later Wins) Conflict Resolver to resolve conflicts based on the latest updated time. However, ...
7
votes
3answers
1k 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 ...
0
votes
0answers
112 views

How to merge multiple SQL Server DBs to one central DB

I am working on 25 identical DBs (SQL Server 2014) installed in 25 Branches. I need to merge the data of these DBs into one central DB, daily.I tested Replication (merge) method. As my servers are ...
1
vote
2answers
727 views

Replicate only specific records of a table

I have setup a merge replication and have got a new requirement: The records of a table should not be replicated until the [state] column is changed from 0 to 1. I have created a filter for the ...
2
votes
1answer
767 views

Merge replication gone wrong, and snapshot is timing out

I have a merge replication set up between one Publisher and 3 Subscribers, replicating a single database with around a 100 different tables of various sizes. It's "real-time" replication running ...
1
vote
0answers
381 views

Merge replication: some subscribers initializing by downloading changes multiple times

I have a database in merge replication with about 25 subscribers, all accessing the publisher/distributor over a satellite connection (high latency, low bandwidth). Recently, as part of a planned ...
2
votes
0answers
95 views

How Much Overhead Does Web Sync Add?

I am running merge replication in SQL2012 using web sync. Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection? ...
3
votes
0answers
278 views

Merge replication sync fails after ALTER TABLE… NOT NULL

We have a SQL Server 2005 database that uses merge replication to sync to SQL Compact Edition subscriptions. We added a column to a table using: ALTER TABLE Shifts ADD COLUMN StateOrProvince NOT NULL ...
3
votes
1answer
349 views

Merge Replication Validation Failure

We are getting a bizarre error with some of our users while syncing with SQL Server 2008 R2 Service Pack 3. Validation fails even though the row count and expected row count actually match! Error ...
3
votes
0answers
1k views

“The schema script could not be propagated to the subscriber” error has SQL code instead of file name

This type of error is unfortunately not uncommon. One report of many is this one on Stack Overflow: https://stackoverflow.com/questions/11360331/sql-server-merge-replication-error-the-schema-script-...
12
votes
1answer
900 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
140 views

Merge Replication query causing slow performance

I have three databases (one publisher, two subscribers) running merge replication and this morning noticed very slow performance. They sync on 10 second intervals but this morning it was taking much ...
1
vote
1answer
56 views

Is MSMerge_History.time in GMT or local server time?

Is the time column in the MSMerge_History table GMT or local distribution server time?
2
votes
1answer
426 views

SQL Server 2008 Triggers and Merge Replication

I am trying to have a trigger fire when the Merge agent inserts or deletes data into / from a table. It is supposed to insert data into a report table for use with SSRS. I DO NOT have the "NOT FOR ...
2
votes
1answer
433 views

Merge Replication API with SQL Server 2012 / 2014

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 ...
1
vote
3answers
3k views

SQL Server Replication with 2 systems in different locations

I have 2 Servers with static public IP Addresses located one in UK and another in US. Can I implement SQL Replication on these 2 servers located in 2 different locations accessible via public IP ...
1
vote
0answers
457 views

Query slow on subscriber but fast on publisher (Merge Replication)

As the title suggests, I am having issues with performance with my subscriber. I run the exact same query (it's a recursive query with a few joins but nothing too serious). I can run this query on my ...