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

SQL Server - Hub/Spoke disconnect model

Here's my situation - I know it's not the first time it's come up but I can't find just the right documentation to address all of my concerns....we have an environment where there needs to be a centralized/roll-up web service and data warehouse for…
tntwyckoff
  • 539
  • 5
  • 17
0
votes
1 answer

Issue With Web Synchronization & Merge Replication Microsoft SQL Server / 2008 r2

I am extending our network by placing a xenserver box at a remote location to reduce outages for our web resources. All our servers are on xenserver, with MS Server 2008r2 and SQL Server 10. I must add I am a developer, not a sysadmin, so I have…
Si Barker
  • 1
  • 3
0
votes
1 answer

How to change the physical location of the publisher server with Merge Replication?

I have set up the merge replication between central server and multiple clients and its been working smoothly. Now I have a requirement in which we are planning to change the location of the central server and shift to other location. What are the…
AnandPhadke
  • 13,160
  • 5
  • 26
  • 33
0
votes
2 answers

SQL Server Merge Replication: Synchronizations timing out, applying thousands of un-needed schema changes

We have a merge publication which uses a range of replication methods across ~80 articles (host_name filtering on one table, join filtering for several others; some tables using bi-directional synchronization direction, others with 'download only,…
willycs40
  • 63
  • 6
0
votes
2 answers

ALTER TABLE DROP COLUMN failed because 'rowguid' is currently replicated

We have a SQL Server 2012 database that was migrated from SQL Server 2000. The 2000 version had replication on it, but this was removed. I am currently trying to remove a few deprecated columns in several tables, but I'm getting the following…
user884248
  • 2,134
  • 3
  • 32
  • 57
0
votes
2 answers

SQL Server Merge - Pull replication error

I have a configuration problem to create a Merge/Pull replication between two databases SQLServer 2012. The machine Publisher is a Windows Server 2008 R2 not in windows domain, this Server is also the Distributor. The machine Subscriber is a Windows…
Alessandro S
  • 1
  • 3
0
votes
1 answer

Automate SQL Merge Replication Configuration

I have a stored procedure that takes a "DBname" parameter and creates a new database from a backup, naming the new database with the parameter. So if i execute the sproc with param = 'myDB1" it creates a new database from an existing backup and…
Blaze
  • 1,863
  • 7
  • 23
  • 40
0
votes
1 answer

Rename a NOT NULL column with no default in a SQL Server 2000 table in Merge Replication

Using sp_repladdcolumn I can either: 1) add a column that allows nulls; or 2) add a column with a default value that does not allow nulls. Without dropping and recreating the whole subscription I would like to: 3) add a column with no default value…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
0
votes
2 answers

SQL Server Replication Add Check Constraint in Publisher Table

I'm new to replication and would like to know the impact of creating a check constraint on a publisher table both in case of merge replication and transaction repl. Both the cases, repl is already setup, would the replication break if I set up the…
user2537249
  • 41
  • 3
  • 7
0
votes
1 answer

What happens if I truncate MSmerge_current_partition_mappings

We're still having massive issues with our Merge Replication (1 Publishers, 900 subscribers) Inserting into certain tables can take up to 20 minutes and I'm trying to find a route cause. Execution plans aren't really helping and what I have found…
Gavin Mannion
  • 875
  • 1
  • 14
  • 32
0
votes
0 answers

AS400 subscription to SQL Server 2008 R2 Std

I am aware that you can create a subscription on an AS400 box to a SQL Server box. My question is, can you have replication if you do not have active journals going on some of the AS400 tables?
Jason Squires
  • 27
  • 1
  • 9
0
votes
1 answer

Does merge replication lock subscriber database?

I need to configure merge replication between 2 databases. These databases have foreign key integrity, which makes the replication not work, so I resorted to: Dropping all FKs on subscriber database, Replicating, and Recreating the FKs. This…
Georgi Gamzakov
  • 11
  • 4
0
votes
1 answer

Keep Publication while migrating database in SQL Server 2008 R2

I have a large database with merge-replication on it that needs to be moved to a different server. There is one publisher, but there are close to 200 subscribers, so I don't want to recreate them all manually. Is there a way to make this move so…
ijb109
  • 942
  • 1
  • 19
  • 30
0
votes
1 answer

Prevent sql server Compact as a subscriber to anonymous merge pull publication

Is there a way to specify as a property to my publication, to say it doesn't need to handle sql compact subscriptions? Sql server 2008 R2 as the publisher, when I originally created the publication, I set the compatibility to 2005 and up. I…
Brian
  • 1,337
  • 5
  • 17
  • 34
0
votes
2 answers

SQL Server Compact merge replication with NT Authentication

I am doing merge replication between SQL Server CE, 3.5 SP2 and SQL Server 2012 via IIS / Websync. Everything works perfectly when I use DB Authentication to connect with the publisher. If I switch it to NT Authentication, I get the following error…
Progger
  • 2,266
  • 4
  • 27
  • 51
1 2 3
…
17 18