I am using CDC for database change notification.
But some suggested to not use CDC.
I found this other option SQL Dependency.
Which one is better option among SQL Dependency and CDC?
Asked
Active
Viewed 443 times
0
Srinivas
- 2,479
- 8
- 47
- 69
-
1There is no better or worse absent requirements. What are you trying to do? – Ben Thul Apr 09 '14 at 11:48
1 Answers
1
Without having read extensively on the two and their differences, one thing that jumps out immediately is the fact that CDC is only available on SQL Server Enterprise. It also looks like CDC would use significant storage space and incurs a performance hit but SqlDependency is only recommended for a small number of dependent clients.
jmcilhinney
- 50,448
- 5
- 26
- 46