question

16044469 avatar image
0 Votes"
16044469 asked 16044469 commented

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

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


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

sql-server-general
image.png (76.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered 16044469 commented

Hi @16044469,

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thank you. I can only think about another way.

0 Votes 0 ·