什么是本机CDC和复制服务器CDC之间的区别？ [英] Whats the difference between native CDC and replication server CDC?

问题描述

大家好

我对'Native server CDC'和'Replication Server CDC'的概念感到困惑。这两者之间的区别是什么???我在Microsoft SQL Server中阅读了有关Replication Server的文章，但是我没有在Native CDC上获得太多东西。

需要这方面的帮助：（



问候



我尝试过：



我试图在一个ETL工具中使用一个名为：'MAP CDC'的转换，在那里我遇到了这个概念，我遇到了这种差异。

解决方案

更改数据捕获记录插入，更新和删除应用于SQL Server表的活动。为修改的行捕获列信息和将更改应用于目标环境所需的元数据并存储在镜像跟踪源表的列结构的更改表中。

这意味着我们必须更改它。



但是对于复制，如果用户在，我们不需要改变。它不断更新或复制新价值。



阅读本文以获得更好的想法..



https://msdn.microsoft .com / zh-CN / library / cc645937.aspx



https://msdn.microsoft.com/en-us/library/hh403414.aspx

Hi All
I was confused with the concepts of 'Native server CDC' and 'Replication Server CDC'. What is the differences between the two???I read the article about the Replication Server in Microsoft SQL server, however I did not get much stuff on Native CDC.
Needed help on this:(

Regards

What I have tried:

I was trying to use one transform called :-'MAP CDC' in one ETL Tool,where I came across this concept, where i encountered this differentiation.

解决方案

Change data capture records insert, update, and delete activity that is applied to a SQL Server table. Column information and the metadata that is required to apply the changes to a target environment is captured for the modified rows and stored in change tables that mirror the column structure of the tracked source tables.
That means we have to have to change it.

But for replicated , if a user is on we do not need to change. It keeps updating or replicating the new values.

Read this for a better idea..

https://msdn.microsoft.com/en-IN/library/cc645937.aspx

https://msdn.microsoft.com/en-us/library/hh403414.aspx

这篇关于什么是本机CDC和复制服务器CDC之间的区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！