更改数据捕获 - Microsoft 捕获数据更改的最佳实践？
我们的开发团队就捕获某些表中数据变化的最佳方式进行了一些辩论。我对变更数据捕获印象深刻，并相信这是捕获此类数据的最佳方式，而这正是 Microsoft 设计 CDC 的目的。
对于那些必须处理此类事情的人来说，您是否发现 CDC 是 Microsoft 捕获表中数据更改的最佳实践方法？
非常感谢。
We have some debate on our development team regarding the best way to capture changes in data in some of our tables. I am very impressed with Change Data Capture and believe it is the best way to capture this sort of data, and that this is what Microsoft designed CDC to do.
For those of you who've had to deal with this sort of thing, have you found CDC to be the Microsoft best practice way of capturing data changes in tables?
Thanks very much.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
这绝对是最简单、最高效的；如果替代方案是创建触发器并写入审计表，我随时都会选择 CDC。它工作得很好并且只需要很少的设置。
无论它是否最适合您的场景，都需要更多信息。
It's absolutely the easiest and most efficient; if the alternative is to create triggers and write to audit tables, I'd take CDC any day. It works very well and requires little setup.
Whether it would be the best for your scenario, that would require a little more info.
我发现设置和启动 CDC 非常简单，提供良好的性能并且足够灵活，可以满足我的需求。然而，查询该数据以获取详细说明所做更改的结果集似乎非常复杂且缓慢。
我希望看到一些不同的方法来报告这些数据，有人愿意提供一个很好的示例，显示简单的结果，指示更改的日期时间、字段更改和旧/新值吗？
I've found that setting up and starting CDC is very simple, provides good performance and is flexible enough for my needs. However, it appears to be very complex and slow to query that data to get a resultset detailing the changes made.
I would love to see some different approaches for reporting on this data, anyone care to provide a good sample showing simple results indicating datetime of change, field changed, and old/new values?
CDC可以在SQL Server中轻松实现。
SQL Server 2005 和 SQL Server 2005上述具有执行“更新后”、“插入后”和“删除后”触发器的功能，可用于数据归档和数据捕获，无需任何额外的编程。
此链接指定如何实现 SQL Server 数据库中的 CDC。
CDC can be easily implemented in SQL Server.
SQL Server 2005 & above has features of executing ‘after update’, ‘after insert’ and ‘after delete’ triggers that can be used for data archiving and data capturing without any additional programming.
This link specifies how to implement CDC in SQL Server database.