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

Custom UniqueId for merge replication on sql server 2008?

When doing merge replication, is the column ROWGUIDCOL compulsory? Can I use a custom column I have created that will be unique across all databases? Does this mean I have to use GUID as my primary key or can i have a gUID column and my custom id…
user3138120
  • 11
  • 1
1
vote
1 answer

How to programmatically start SQL Server 2005 merge replication

We currently have merge replication set up to merge certain tables between two databases. I need to programmatically start one of the publications to make sure data has been synchronized prior to starting a certain job. SQL Server Books Online has…
Jeff Widmer
  • 4,746
  • 6
  • 37
  • 51
1
vote
2 answers

SQL Server Merge Replication Problems

I have Merge replication setup on a CRM system. Sales reps data merges when they connect to the network (I think when SQL detects the notebooks are connected), and then they take the laptops away and merge again when they come back (there are about…
Ryan Stephens
  • 51
  • 5
1
vote
1 answer

How do you do load and performance testing on SQL Server Merge Replication?

Any ideas on how I can do load and performance testing on SQL Server 2012's merge replciation? We do replication on millions of records per day. And so we have a requirement to measure how many records it can replicate over a period of time. As an…
Rafferty
  • 937
  • 1
  • 9
  • 16
1
vote
1 answer

SQL server transactional replication, change distribution server

I have a SQL 2005 database which is published with dozens of (mostly) transactional publications and dozens of subscribers . Currently we have a local distributor. I'm trying to improve our HA for this setup and am looking at mirroring the…
Steve LaRochelle
  • 11
  • 3
1
vote
0 answers

Merge Replication and varbinary(max)

I have an issue with an existing application that uses merge replication. The replication sends varbinary(max) data (images) and usually not a problem as the usually only a handful of images will be send at once via the subscriber. However, the…
Dan Bater
  • 303
  • 2
  • 6
  • 13
1
vote
1 answer

Merge replication between sql server 2008 and 2000

Good day guys, I have one issue I'm trying to organise Merge replication between two servers 2000 and 2008. I tried two variants: First: I made publication at Sql server 2000 and when I tried to made subscription at 2008 I received following…
Denis Voronchuk
  • 23
  • 4
1
vote
1 answer

unable to delete merge pull subscription

Environment: Merge pull subscription with anonymous subscribers, using web sync, publisher is 2008R2, subscribers are SQLEXPRESS 2008R2. Issue: I run sp_dropmergepullsubscription on subscriber and sp_dropmergesubscription on publisher, subscription…
Brian
  • 1,337
  • 5
  • 17
  • 34
1
vote
0 answers

SQL Merge Replication ignores filter

I have a merge replication (SQL 2005) with a filter. The filter is on table delLog and says WHERE 0 = 1, so all the data is only uploaded, not downloaded. When I want to download my data, and it comes to this table it says downloading table delLog…
abc
  • 2,285
  • 5
  • 29
  • 64
1
vote
0 answers

cannot insert duplicate key row in object dbo.msmerge_tombstone with unique index 'uc1MSmerge_tombstone

I have a merge replication setup in a server.I took the backup of subscriber database and restored it in another server with keep replication on(i restored it in entire different server where no replication is setup). When i try inserting bulk data…
winman
  • 119
  • 8
1
vote
1 answer

Is whether a replication is continuous queryable anywhere?

Can I find whether a replication is continuous somewhere in the distribution or msdb databases on SQL Server database servers? (both 2005 and 2008) Background: I'm making a replication monitor system that will alert (by email) when a replication…
Twon-ha
  • 944
  • 7
  • 21
1
vote
1 answer

Is there an easy way to verify replication articles are correct?

On a Publication (secondarily, a Subscription), is there a script or command I can run that verifies that the articles currently in place match what is expected and/or correct? If changes were manually made to a replication database (i.e. a table's…
Mark Carpenter
  • 17,445
  • 22
  • 96
  • 149
1
vote
0 answers

SQL Server 2005 - how can I delay the first replication alert?

I have SQL Server 2005 Merge replication set up, and a single subscriber which is setup as a pull subscription. It runs on a schedule of once per minute. I would like to be alerted if the SQL Server replication agent has been failing for a certain…
roswellcat
  • 36
  • 5
1
vote
0 answers

Preferred SQL Server database synchronization method

For years I've been using SQL Server merge replication to replicate a SQL Server with several SQL Server Compact databases that I've had, always having it in the back of my mind that I should probably upgrade/switch to the Microsoft Sync Framework…
Phil
  • 1,852
  • 2
  • 28
  • 55
1
vote
2 answers

merge replication - can't create snapshot - timeout - sql server 2008

I have a SQL Server 2008 database, and I need a mergereplication because i want to sync with mobile devices afterwards. So I created a replication but when it comes to start the snapshotagent, the agent tries to start for about 20 minutes and then…
abc
  • 2,285
  • 5
  • 29
  • 64
1 2 3
…
17 18