The following list describes the benefits of using MS SQL Server CDC:
-
No triggers and stored procedures required.
-
Originating applications and transactions run faster.
-
Throughput from source to target data is more efficient.
-
Consumes fewer system resources.