SQL server for Linux does not support Peer-to-Peer replication?

新雨 史 21 Reputation points
2021-03-23T02:08:46.84+00:00

我目前正在SqlServer for Linux上进行 Peer-to-Peer replication,我有两个实例,目前已经成功在两个实例上分别进行了对等发布,但是当我配置对等拓扑时,出现了问题:
![80443-image.png]1

如你所见,我没有办法正常连接到另一个实例。
所以,SqlServer for Linux不支持对等复制吗?

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,825 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor
    2021-03-23T06:26:11.737+00:00

    Hi @新雨 史 ,

    Welcome to Q&A.
    Unfortunately, Peer-to-Peer replication is not supported to SQL Server on linux.
    The following replication features are supported on SQL Server 2017 (14.x) (CU18) and later support SQL Server Replication for instances of SQL Server on Linux:

    • Snapshot replication
    • Transactional replication
    • Replication with non-default ports
    • Replication with AD authentication
    • Replication configurations across Windows and Linux
    • Immediate updates for transactional replication

    Please refer to this doc for more details.
    In addition, this is a English spoken forum, so it is better to post the questions in English, so that the people here will help you more effectively.

    Best Regards,
    Amelia


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread


0 additional answers

Sort by: Most helpful