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

Merge Replication for new created tables

I have two SQL Server 2008 R2 Standard servers and they are using merge replication, sometimes new tables are created in the subscriber and I want it to be replicated to the publisher. Is there an option in SQL Server that allows me to replicate…
Kronass
  • 5,266
  • 3
  • 19
  • 25
0
votes
0 answers

Merge Replication - Detect nonlogged agent shutdown

I have never worked with SQL Server replication and am now in an environment with SQL Server 2012 merge replication. On 3/29 and 3/30 there are 13 of 19 replication jobs which are failing with detect nonlogged agent shutdown on the subscribers. …
0
votes
1 answer

How to replicate huge data table in SQL Server 2012

I have the same database on two servers and I am using merge replication for around 35 tables, and it is working fine. But whenever I add 2-3 more tables with around 1 million records, the replication breaks after some time/days. Can I do 2…
0
votes
1 answer

Restore Subscriber with a different DB Merge Replication

I have a Publisher and a Subscriber using pull subscription at Merge Replication. Let's say that the shared folder with the snapshot has 50GB size. I have a scenario in mind that aims to minimize bandwidth during transmission. Can I take a backup…
Manos
  • 77
  • 1
  • 10
0
votes
1 answer

Merge Replication could not drop object due to Foreign Key Constraint

Good Day Everyone. I am slightly confused here. (it doesn't take a lot to confuse me though) I have a merge replication and it started giving me this error: Could not drop object 'TableName' because it is referenced by a FOREIGN KEY constraint.…
0
votes
1 answer

Can merge replication operate with 0 ms delay, i.e. be real-time?

I'm facing an issue that I have two identical databases on different servers and both working as read/write and data are inserted on both. The thing is there is a merge replication between the two databases and it's working fine but there is a…
0
votes
0 answers

MSSQL server replication - compatibility level

I currently have two SQL servers in a merge replication setup. The publisher is running SQL Server 2016 Standard and the subscriber is running SQL Server 2016 Express. For some reason i am not able to change the compatibility of the publication in…
0
votes
1 answer

How to make SQLServer Web Merge Replication use non-default port?

I'm setting up a web synchronization for SQL Server Merge Replication. My IIS box is in my DMZ, and the SQL Server machine is behind the firewall, so I need to specify a non-default port (not 1433) to get to the publisher and distributor. I've…
longofest
  • 616
  • 5
  • 16
0
votes
1 answer

Can I Configure SQL Server 2012 Replication on Windows 10 Ultimate?

I have windows 10 Ultimate, I need to install SQL Server 2012 Full Edition and configure SQL Server Replication on it, is that possible or must work on Windows Server?
0
votes
0 answers

stored procedure MSenumgenerations90 is slowing down merge replication

I have a merge replication that has been running fine for a year (the system has been active for several years but I recreated the replication a year ago because of some other problems). Everything is still working but when someone is…
Dratskapoo
  • 11
  • 5
0
votes
1 answer

What is the "Replication" key for in a SQL Server connection string?

In a SQL Server connection string you can specify a boolean value for the Replication key, for example: Data Source=.;Initial Catalog=Example;Integrated Security=True;Replication=True; The closest I can find to documentation of this is here, which…
0
votes
1 answer

is it possible to do the Merge Replication in databases that having two different database structures?

is it possible to do the Merge Replication in databases that having two different database structures ?
0
votes
1 answer

Replicate trigger on subscriber in merge replication of SQL Server

I have deployed 1 subscriber and 1 publisher server in merge replication configuration of SQL Server. I added a table along with a trigger on that table on publisher and want to replicate that table and trigger on subscriber. I have set 'replicate…
NI3
  • 27
  • 1
  • 6
0
votes
0 answers

SQL merge replication - Violation of PRIMARY KEY constraint on download only table

Recently some synchronizations have been failing. The last message shown in the replication monitor and in their local replication logs is: The process is waiting for a response from the query '{call …
0
votes
0 answers

sql merge replication trace

Dear all as i am using SQL merge replication in OLTP environment in which there is about 2 publishers and 28 subscribers. One row has been replicated from one subscriber to another subscriber. i just wanna trace its time of replication. can any one…