Tag: Merge

ReplTip – Technique to exceed column limits for Merge Replication

Chris Skorlinski [MSFT] Troubleshooting April 29, 2017

Chris SkorlinskiMicrosoft SQL Server Escalation Services While working with a customer on a Merge Replication project, we encounter a potential road block. They had a published table which exceeded the number of columns allowed for Merge Replication. From this article https://technet.microsoft.com/en-us/library/ms151749(v=sql.105).aspx: If your application does not require column-level tracking, it is recommended that you use
Read More »

Challenges running Continuous Merge Agents

Chris Skorlinski [MSFT] Best Practices August 14, 2016

Chris SkorlinskiMicrosoft SQL Server Escalation Services I wanted to cover in this blog challenges you’ll encounter running Merge Agent on continuous schedule. These are Merge Agents whose SQL Server Agent jobs schedule are set for “Start automatically when SQL Server Agent starts”. Each time a Merge Agent starts it logs start time in
Read More »

Walkthrough of Merge Replication with AlwaysOn High Availability

Chris Skorlinski [MSFT] Try This May 31, 2016

I’ve been working with a customer to setup and test Merge Replication Publisher in AlwaysOn Availability Groups. To quickly spin up a test scenario, I used our Microsoft Azure AlwaysOn template for SQL Server 2014 and within a few minutes had a complete AlwaysOn Availability Groups environment with 2 SQL Server 2014 availability replicas, Primary
Read More »

Merge metadata cleanup changes in SQL Server 2012 SP2 and SQL Server 2014 SP1

Chris Skorlinski [MSFT] Product Updates September 28, 2015

Content provided by: Hugo Nunes, Microsoft Support Escalation Engineer TITLE: Merge metadata cleanup changes in SQL Server 2012 SP2 and SQL Server 2014 SP1 Abstract: This article briefly describes the change in the merge metadata cleanup logic introduced in SQL Server 2012 SP2 and SQL Server 2014 SP1, and provides some recommendations Terms and
Read More »

Primary Key design considerations for Merge Replication

Chris Skorlinski [MSFT] Best Practices September 20, 2015

by Holger Linke, Microsoft SQL Escalation Engineer GUIDs and Clustered Indexes Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones. With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical. As you know, each row is
Read More »