search

Home >Database >Mysql Tutorial >使用SQLServer 2008的CDC功能实现数据变更捕获

使用SQLServer 2008的CDC功能实现数据变更捕获

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 15:20:111309browse

USE AdventureWorks ; GO EXECUTE sys . sp_cdc_enable_table @source_schema = N'Person' , @source_name = N'ADDRESS' , @role_name = N'cdc_Admin' -- 可以自动创建 , @capture_instance = DEFAULT GO EXECUTE sys . sp_cdc_enable_table @source_schema

USE AdventureWorks;

GO

EXECUTE sys.sp_cdc_enable_table

    @source_schema = N'Person'

  , @source_name = N'ADDRESS'

  , @role_name = N'cdc_Admin'--可以自动创建

  , @capture_instance=DEFAULT

GO

EXECUTE sys.sp_cdc_enable_table

    @source_schema = N'Person'

  , @source_name = N'Contact'

  , @role_name = N'cdc_Admin'--可以自动创建

  , @capture_instance=DEFAULT

GO

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：解剖SQLSERVER 第十五篇 SQLSERVER存储过程的源文本存放在哪里Next article：解剖SQLSERVER 第十一篇 对SQLSERVER的多个版本进行自动化测

Related articles

See more