Tag: merge replication

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Merge Replication

Troubleshooting SQL Server 2017 Merge Replication If you have problems with SQL Server 2017 merge replication, review this troubleshooting checklist to find potential solutions. 1. Check that account the SQL Server and SQL Server Agent services runs under belongs to the Administrators local group and is a member of the Domain Users group. The LocalSystem account does not have network…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using Merge Replication in SQL Server 2017 (Part 2)

Tips for using Merge Replication in SQL Server 2017 (Part 2) If you do not need continuous replication, do not configure the Merge Agent to run continuously. Try to schedule the Merge Agent to run at regular intervals instead of running continuously. Try to schedule it during CPU idle time and slow production periods. By using it, you can decrease…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using Merge Replication in SQL Server 2017 (Part 1)

Tips for using Merge Replication in SQL Server 2017 (Part 1) Avoid using join filters with five or more tables. Because join filters with five or more tables can significantly degrade merge replication performance, you should avoid join filter for the small lookup tables, or denormalize the database design instead of using join filters with five or more tables. Use…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 Merge Replication

Troubleshooting SQL Server 2016 Merge Replication If you have problems with SQL Server 2016 merge replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 Merge replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
SQL Server

Some tips for using Merge Replication in SQL Server 2016 (Part 2)

Some tips for using Merge Replication in SQL Server 2016 (Part 2) Avoid publishing unnecessary data. Try to restrict the amount of published data. This can results in good performance benefits, because SQL Server will publish only the amount of data required. This can reduce network traffic and boost the overall replication performance. Set the “Maximize Throughput for Network Applications” […]

SQL Server

Some tips for using Merge Replication in SQL Server 2016 (Part 1)

Some tips for using Merge Replication in SQL Server 2016 (Part 1) Avoid replicating text, ntext and image columns. These data types require more storage space and processing than other column data types. Consider setting the -OutputVerboseLevel parameter of the Merge Agent to 0. This parameter specifies whether the output should be verbose. There are three available values: 0 – […]

SQL Server

Troubleshooting SQL Server 2014 Merge Replication

Troubleshooting SQL Server 2014 Merge Replication If you have problems with SQL Server 2014 merge replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 Merge replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]

Pro Members SQL Server Standard Members

SQL Server 2014 Merge Replication Optimization Tips (Part 2)

SQL Server 2014 Merge Replication Optimization Tips (Part 2) Do not forgive to script your replication configuration. Because scripting the replication configuration is a key part of any disaster recovery plan for a replication topology, you should script your replication configuration from the replication wizards or from the Replication folder in Microsoft SQL Server Management Studio. If you do not…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2014 Replication – Part 4

SQL Server 2014 Replication – Part 4 Author: Basit A. Farooq Editor’s note: In this fourth part of my SQL Server 2014 Replication article series, you’ll learn about how to configure Merge replication. You’ll also learn about Merge replication conflict management. Creating a Merge publication The steps for creating a Merge publication are similar to creating a transactional publication. However,…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2014 Replication – Part 3

SQL Server 2014 Replication – Part 3 Author: Basit A. Farooq Editor’s note: In this third part of my SQL Server 2014 Replication article series, you’ll learn about working and configuration of Transactional replication. You’ll also learn about working of Merge replication. Transactional replication Transactional replication sends incremental changes and transactions to the Subscribers. Transactional replication gives you a shorter…...

This content is for Pro, Pro Member, Standard and Standard Member members only.
Log In Register