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
1 answer

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 transactional replication can do the trick. The problem…
Lamar
  • 1,761
  • 4
  • 24
  • 50
1
vote
1 answer

SQL Exception on immediate reconnect

I have a winform app that uses LinqToSql as it's DAL. There is a Central SQL DB and each laptop has a local SQLExpress DB. A seperate module, using Merge Replication, keeps the two in sync. When connection is lost to the central DB it 'fails…
Refracted Paladin
  • 12,096
  • 33
  • 123
  • 233
1
vote
0 answers

replication over internet- sql server 2012

I'm having trouble configuring merge replication over untrusted domains. I have a remote serverA which has a real IP and I configured this server to be his own distributor and publisher and also a ftp-server for the snapshot folder to be shared. I…
Reham AMS
  • 11
  • 3
1
vote
1 answer

SQL Merge replication : How to tell what has changed.

I have a query regarding the merge replication. Is there any stored procedure which gives me exactly the column values that have been changed at the server, because of which the row will be replicated to the subscriber in the next replication…
Saurabh
  • 241
  • 2
  • 12
1
vote
1 answer

Partitioned table in publication and a non-partitioned table at subscriber in Sql Replication

I was wondering whether we can use partitioned tables at the Publication level and non-partitioned tables at the Subscriber level? I was reading this article, Replicating Partitioned Tables and Indexes It doesn't mention anything about what if…
techno
  • 192
  • 13
1
vote
1 answer

Choosing the best High Availability solution for a Reporting Database and Application Frontend

I have inherited a system with 3 databases running on a single server (SQL Server 2012): StagingDB (250GB) ReportingDB (350GB) AppDB (500GB). Every day the following process happens: Several GB of plain text CSV data is deposited on the…
Adam
  • 1,932
  • 2
  • 32
  • 57
1
vote
2 answers

SQL Server Merge Replication error

I am getting a very strange error message at one of our client sites and I am having very little luck trying to figure out what is going on. Hr=80040154 ERR:OpenDB failed getting pub version 28627 That is the error message that is from the Merge…
Bryan
  • 2,775
  • 3
  • 28
  • 40
1
vote
0 answers

Merge replication changing rowguid

We have a diversified environment. It is composed by 194 publishers and the total of 209 subscriptions. The publisher and distributor both are SQL Server 2008 R2. As subscribers we have 2008 R2 (different versions and sps) and 2000 (different…
Carolina Erba
  • 11
  • 1
1
vote
1 answer

Bulk Inserts Failing with SQL Server Merge Replication Identity Range Management

We have an issue with merge replication where we have a background process inserting rows in bulk. These inserts sometimes fail with the message that The insert failed. It conflicted with an identity range check constraint in database ‘′,…
Zephryl
  • 343
  • 2
  • 9
1
vote
1 answer

SQL Server Replication Action if name is in use questions

When configuring a new Merge Replication, setting properties of all articles, I'm having a problem. In Destination Object -> Action if name is in use, I can select four different options. I'm trying to figure out what is each one. I'm not finding…
Alexandre_Almeida
  • 131
  • 1
  • 3
  • 10
1
vote
0 answers

SQL Server Merge replication drop and creates subscriber table without any schema change

After adding table to replication it appears in sysmergearticles with status "6" and its not changing after sync, so replication always make drop/create table at subscriber. It started to appear suddenly and i have other tables that works good, but…
Sergey Lobanov
  • 365
  • 3
  • 14
1
vote
3 answers

How to take a merge replication back up?

I have a windows server 2012 with SQL Server 2012 configured with Merge replication with three subscribers. I want to take a full back up the merge replication in case of total sql server crush. I am not sure how to take it or which databases to…
mox-du
  • 107
  • 9
1
vote
0 answers

Merge replication error the schema script could not be propagated to the subscriber SQL Server 2008

I am with replication so after trying for 1 month I am able to initialize publisher on remote system and subscriber on my local system. When I run job at subscriber end I get an error the schema script AccountNotic1234.sch could not be propagated…
Hot Cool Stud
  • 1,145
  • 6
  • 25
  • 50
1
vote
1 answer

SQL Server 2005 Merge Replication: Under what circumstances would the base snapshot expire?

Obviously changing schema, adding / removing published articles etc expires the snapshot, but is there anything else that would cause the publication to expire? We're seeing a snapshot expiring without any changes to schema or data on the server. If…
Gareth
  • 2,424
  • 5
  • 26
  • 44
1
vote
1 answer

Merge replication Error at the subscribers

I was working on a merge replication on SQL SERVER 2012. I have one central server with the publication and distribution configured on the same machine.I have another three machines with SQL SERVER 2012 as subscribers. The replication is working…
mox-du
  • 107
  • 9
1 2 3
…
17 18