Bidirectional replication - SQL Server supported editions

Christiaan Bronkhorst 21 Reputation points
2022-02-08T09:41:15.013+00:00

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.

Thanks

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
    2022-02-09T03:06:00.223+00:00

    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
    2022-02-08T10:56:12.247+00:00

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