基本可用性组问题 [英] Basic Availability Group Question

问题描述

我在AWS（标准版）中安装了源SQL Server数据库。我想将数据的副本带到内部，以便通过Informatica报告和提供ETL处理数据。

I have a source SQL Server database setup in AWS (Standard Edition). I would like to bring copy of the data to in-house for reporting and feeding data for ETL processing via Informatica.

现在，我发现这篇文章

https://docs.microsoft.com/en-us/ sql / database-engine / availability-groups / windows / basic-availability-groups-always-on-availability-groups？view = sql-server-2017

BASIC AG不允许在副本上进行读取访问。我的理解是Full / Advanced AG两端都需要Enterprise Edition，BASIC AG也是如此（两端标准）。我假设即使我在辅助
服务器上有企业版，我仍然只能设置BASIC AG。

That says BASIC AG doesn't allow read access at replica. My understanding is Full/Advanced AG will need Enterprise Edition on both ends and the same will be true for BASIC AG (Standard on both ends). I assume even if I have an Enterprise Edition on the secondary server still I can only setup BASIC AG.

这个澄清的原因是我们内部有企业版环境，我们想要阅读上述数据。

The reason for this clarification is that we have Enterprise Edition in our internal environment and we want to read the data as stated above.

是否有可能？

推荐答案

您需要两个SQL服务器才能从企业中读取辅助服务器。

You would need both SQL server to be Enterprise to read from the secondary.

您应该查看
事务复制 而是与SQL Standard一起使用，以便将满足您的需求。

You should look at transactional replication instead as that works with SQL Standard so that will suit your needs.

谢谢，

马特

这篇关于基本可用性组问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！