是否存在类似于SQL Server中的Oracle实时复制的任何内容。 [英] Is there anything that is similar to Oracle Real time Replication in SQL Server.

问题描述

下面这个问题适用于SQL数据库和SQL托管实例？

This question below applies to both SQL database and SQL managed instance?

我想实时复制数据库 到另一个数据库。 SQL Server中有什么可用的。指向该信息的链接很有用。

I would like to replicate database in real time  to another database. Is there anything available in SQL Server. A link to the information is helpful.

如果我们在主动节点和副本节点之间使用SQL AG，那么容错是什么？ 有时副本可能与主数据库不同步？

Also what is the fault tolerance if we use a SQL AG between the active node and the replica node?  Sometime the replica can be out of synch from the primary database?

dsk

推荐答案

您好，

感谢您的反馈。您可以关注此视频，它将帮助您实时复制数据库。

Thanks for your feedback. You can follow this video which will help you enabling the replication of database in real time.

https://azure.microsoft.com/en-in/资源/视频/ sql-database-enable-geo-replication-in-azure-portal /

您可以参考这个帖子，我相信这将解答您对故障转移的疑虑。

You can refer this thread, I believe this will answer your concerns regarding failover.

https://serverfault.com/questions/738986/what-failover-does-sql-azure-support-automatically

如果您还有任何疑问，请告诉我们。

If you have still have any queries please let us know.

希望有所帮助。

这篇关于是否存在类似于SQL Server中的Oracle实时复制的任何内容。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！