Bidirectional replication - SQL Server supported editions

Christiaan Bronkhorst 21 Reputation points

Hi all,

Does the SQL Server Standard Edition support bidirectional replication?

It is not specifically listed in this Microsoft doc: editions-and-components-of-sql-server-version-15

I understand bidirectional replication is a type of transactional replication, also so is peer-to-peer replication, but the latter requires a SQL Server Enterprise Edition.

Any clarification would be much appreciated.


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,607 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,071 Reputation points Microsoft Vendor

    Hi @Christiaan Bronkhorst ,

    > Does the SQL Server Standard Edition support bidirectional replication?

    Yes, it is supported.

    > I just wanted to confirm that there is not like a restriction on the loopback detector or limits on subscribing to publications or anything weird that might keep us from using the Standard edition?

    Yes, no limits on SQL standard edition.

    By the way, the @German Gutierrez _detection parameter of sp_addsubscription (Transact-SQL) is set to TRUE to ensure that changes are only sent to the Subscriber and do not result in the change being sent back to the Publisher.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 40,576 Reputation points

    The "Merge replication" is a bi-directional one and thats document in the link you posted.
    One restriction: 1 = Subscriber only