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
0 answers

Allow non-db_owner INSERT permissions in merge replication with auto identity range mgmt

I have users with INSERT permissions on a table. They can insert records on the publisher until the table's primary range runs out. Then they start getting this error every time they try to do an INSERT: [Microsoft][ODBC SQL Server…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
0
votes
0 answers

Sql Server replication setup in a high availability clustering system running on a workgroup

We are trying to set up replication for a database in a high availability cluster environment, where an outage of the primary database server will automatically fail over to the secondary server. Furthermore, we are using a workgroup-based…
Richard B. Sorensen
  • 103
  • 1
  • 12
0
votes
1 answer

SQL Server merge replication and vertical partitioning on some tables after scripting of a publication

We have a database that we changed during the time in terms of adding/removing articles, columns to replication articles in a publication. Now when we script out that publication we have lines of code that are telling us that vertical partitioning…
Dejan Dozet
  • 948
  • 10
  • 26
0
votes
1 answer

What will be the best way for Server to server data transmission in an offline satellite environment with low bandwidth

We have a customer which connects to our servers through Satellite. However, they have a major concern that the facilities in which they want to run our applications, at many times have connection issues. So, they want to run our applications…
Abdulqadir_WDDN
  • 658
  • 6
  • 22
0
votes
1 answer

How to change existing triggers to be with 'not for replication' in merge replication in SQL Server?

How to make a script that will change all triggers in a database to be NOT FOR REPLICATION? Is there a system procedure for it or we need to parse its definition and inject NOT FOR REPLICATION?
Dejan Dozet
  • 948
  • 10
  • 26
0
votes
1 answer

SQL Server Replication Issue

I have two locations that was replicating data using sql server merge replication process. I upgraded the db and now I am trying to setup the replication again on the new database. However, I am concern about how do I keep the data that has not been…
Developer Drew
  • 1
0
votes
1 answer

How to replicate two tables with different structures but the same fields?

I have two SQL server databases in different locations.I want to do something like replication. this is my scenario: In the first data base I have a table with following structure: tbl_worker _Name nvarchar(10) family nvarchar(20) State int city …
Raymond Morphy
  • 2,464
  • 9
  • 51
  • 93
0
votes
1 answer

Updating filtered replicated rows on subscriber fails

I have a merge replication scenario with 1 distributor/publisher and many subscribers. There are only a few articles which are unfiltered everything else is filtered by HOST_NAME() and thus creating distinct (nonoverlapping) partitions. I also tried…
Sven Hecht
  • 1,337
  • 1
  • 16
  • 23
0
votes
1 answer

Merge Replication: Are multiple publications better than one big one?

We have merge replication set up in SQL Server 2000. One of our publications has 65 articles in it. This works fine but it is a hassle to modify anything (beyond adding a column via sp_repladdcolumn) because it takes quite a long time to…
mwolfe02
  • 23,787
  • 9
  • 91
  • 161
0
votes
1 answer

SQL Server replication model snapshot, transactional and merge - which is best

I am trying to implement sql server database replication between 2 branch servers to a Head Office Server. My application is a distributed one, the main application is hosted on head office which is controlling the masters and final approvals. The…
George Thomas
  • 125
  • 2
  • 12
0
votes
1 answer

Merge Replication On Live SQL Developer

I have successfully configured merge replication on my local SQL server by creating two instances making one as Publisher and other as distributor. Now to show demo to my client i need it to configure live by making my local system as Subscriber…
Zeeshan Ali
  • 11
  • 2
0
votes
2 answers

removing an object from Publication database sys.sp_droparticle and sp_dropsubscription

SQL Server Admin is not my forte. So please bear with while I explain this A SQL Server 2012 cluster is involved in a Change data capture ( CDC ) effort using a 3rd party CDC utility. for it to work replication needs to be turned on, without…
user1874594
  • 2,277
  • 1
  • 25
  • 49
0
votes
2 answers

SQL Server 2012 Merge Replication - Full Text Indexes

I have an issue setting up merge replication on a SQL 2012 instance. The push of the snapshot to the subscriber is failing and the reason I discovered was because there is a SP that uses a Full Text Index that has not been generated on a table. A…
jcnewman83
  • 189
  • 1
  • 12
0
votes
0 answers

SQL Server replication datatype change from tinyint to int

I am trying to change the datatype of one of the columns of a table which is there in the publisher by using the alter command. And trying to see the changes done at the subscriber end of the table after running the agent. However I'm unable to see…
user8829086
  • 13
  • 3
0
votes
1 answer

SqlCeReplication: using ReinitializeSubscription before each Synchronize?

I'm working on a bug in a legacy Windows Mobile 5 app, which uses SQL CE Replication to sync a SQL CE database with a SQL Server 2005 or 2008 database (using Merge replication). There is some behavior in the application which I don't believe is…
Andy White
  • 86,444
  • 48
  • 176
  • 211
1 2 3
…
17 18