Change Data Capture Tool


(Aaron Willett) #1

Can anyone recommend a good Change Data Capture tool?
We’re running the standard version of SQL, so we do not have access to the one packaged.
We’re looking for a simple way to capture adds/updates/deletes on database tables that we specify–bonus points for being able to narrow it down to a specific user and then be able to report on it.


(Jose C Gomez) #2

Checkout the Red gate SQL Server tools
https://www.red-gate.com/products/

I think they include a change capture stuff, red gate is pretty awesome in general. SQL Prompt is a must.


(Aaron Willett) #3

What is it? An editor of sorts?


(Jose C Gomez) #4

Is a plug in to SQL Studio that does a bunch of really nice stuff. It enhances SQL management studio