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
0
votes
1answer
218 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
311 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
60 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
235 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 ...
0
votes
1answer
77 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
250 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
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
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
1answer
215 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
217 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
0answers
404 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. ...
1
vote
2answers
95 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, ...
5
votes
1answer
3k views

Very slow merge replication synchronization

I had an unforeseen issue with a sub going down (generic error, was probably a connection issue) and now that I've reconnected the sub it is insanely slow re-syncing. It seems to download about 1000 ...
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
724 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
754 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
378 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 ...
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-...
4
votes
1answer
211 views

How does SQL Server Merge Replication maintain referential integrity?

Note: This is a curiosity question about SQL Server. I've been reading about SQL Server's Merge Replication feature, and there's one thing I just don't understand about it: How does Replication ...
1
vote
0answers
135 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 ...
3
votes
1answer
344 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 ...
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?
1
vote
0answers
456 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 ...
1
vote
2answers
783 views

Merge Replication - Deleting from the subscriber database?

I have 2 SQL Server instances where I use merge replication on a database. A developer accidentally inserted data to both the subscriber and publisher at the same time. Now I have data in both ...
1
vote
1answer
752 views

How to delete duplicate rows in merge replication

Somehow two rows in a table that is party to merge replication are identical, including their rowguid. I have no idea how this happened, it is only with two rows in my entire database (which is used ...
1
vote
1answer
290 views

How Merge Replication Works

I'm not DBA at all but I need to do something to synchronize four SQL server databases. I just discover there is a Merge Replication system in SQL Server 2008. At this moment I'm reading the ...
1
vote
0answers
110 views

SQL Server 2012 Merge replication not replicating all changes

Having a problem with replicating a database between two servers, both running SQL Server 2012. We have a table where each site that stores the database updates a record every minute with the current ...
1
vote
0answers
204 views

How to manage old replication issue

Background We are using SQL Server 2008 and we had a merge replication configured (before i joined the company). After that they stopped using it and the didn't delete it and configured transactional ...
2
votes
0answers
1k views

Merge Replication: Error “The insert failed. It conflicted with an identity range check constraint”

For one of our SQL server 2005 enterprise, configured with merge replication, we suddenly start seeing the below error message: The insert failed. It conflicted with an identity range check ...
4
votes
1answer
466 views

Two-way replication between SQL Server 2008 R2 and SQL Server 2008 R2 SP3

I know that in SQL Server you can't have two-way replication between different versions. I wanted to know if SQL Server 2008 R2 and SQL Server 2008 R2 SP3 are considered "different versions"? Did ...
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 ...
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 ...
2
votes
0answers
111 views

Transaction log bloat when writing to table on replicated database with parameterized filter

We are observing abnormally large log writes whenever we update a table that is used for parameterized filter in a merge replication. There are a number of join filters as well. When executing a ...
2
votes
1answer
299 views

How to manually invalidate a pull merge replication snapshot from the publisher

XY Problem background info: I have a pull replication publisher in which I want to add or alter a index and have those changes be applied to the subscriber. The solution to that problem I would like ...
8
votes
3answers
1k views

High tempdb disk I/O during merge replication of BLOBs

Having a merge publication for replicating BLOBs (type image), got very high tempdb disk I/O for my size of data. Publication is download-only and has no filters. High disk I/O is caused by ...
1
vote
4answers
1k views

Script to merge-replicate two MDF database files?

I have a program on a computer and on a tablet. The program uses SQL Server Express to interact with a local database (the same information on both) from a .MDF file. So if I plug the tablet into the ...
2
votes
1answer
913 views

Inserts/updates are extremely slow with Merge Replication in SQL Server 2008

I got hired into a new company and they had merge replication already in place. They have had issues with it to the point I have to evaluate whether to keep it or replace it. The main issue is it ...
3
votes
1answer
2k views

SQL Server 2012 merge replication blocks other insert/updates during sync

I have a merge replication setup between two SQL Server 2012 databases via Pull method. There are several merge replications affecting different table sets (3 sets 2-5 tables each, actually). There ...
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 ...
0
votes
1answer
291 views

How to fix my Merge Replication upload order?

I have several Merge Replication instances in production on SQL 2008 R2. One of them has started to behave oddly in that it appears to attempting to upload the children tables before it uploads the ...
2
votes
0answers
228 views

Merge-Replication: New column doesn't get replicated down by update command

I do this frequently but all clients have this fault: I added a new column to a table using a SQL statement, which causes the column to be created and added to every publication that uses this table. ...
2
votes
1answer
593 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
0answers
302 views

Why are foreign keys ignored on subscribers?

We are using merge replication on SQL Server 2008 R2. There are many tables with foreign keys providing a logical dependence on each other. For this question, let's say there are User and File tables, ...
1
vote
0answers
350 views

Replicating Multiple SQL Servers to Azure and Accessing From Web Apps

I am setting up quite a large system with multiple servers (MS SQL Server), and Office 365 Access DB, and a custom SharePoint web app for reporting purposes. The system should work as follows: Each ...
0
votes
0answers
357 views

Cannot drop constraint in SQL server 2008

When I try to delete a constraint, it gives me the following message: "The constraint is used by merge replication for identity management and cannot be dropped directly. Execute ...
4
votes
1answer
71 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 ...
12
votes
3answers
15k 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?
0
votes
1answer
86 views

Automating SQL Server Merge Replication Processes [closed]

Hi all is there anyway I can automate the entire process of the Merge Replication?