Share via

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.
13,361 questions
0 comments
Accepted answer
  1. CathyJi-MSFT 21,131 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

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 43,246 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