Geek asks and answers

Change data capture - Microsoft Best Practice for data collection?

We have some discussion about our development team regarding the best way to record data changes in some of our tables. I am very impressed with Change Data Capture and I believe that this is the best way to capture such data, and that this is what Microsoft has developed CDC.

For those of you who have had to deal with such things, have you found CDC the best way to intercept data in Microsoft tables?

Many thanks.

+3
source share
3 answers

It is absolutely the easiest and most effective; if the alternative is to create triggers and write to audit tables, I would take CDC any day. It works very well and requires a little tweaking.

, .

+1

, CDC , . , , , , .

, - , , , / ?

+1

CDC SQL Server.

SQL Server 2005 and later has post-upgrade after insert and post-delete triggers functions that can be used to archive data and capture data without any additional programming.

This link indicates how to implement CDC in SQL Server Database.

0
source

More articles:


All Articles