Questions under this tag are expected to relate to Change Data Capture technologies available in many RDBMS server products. Change data capture is designed to capture insert, update, and delete activity applied to Server tables, and to make the details of the changes available in an easily ...
7
votes
2answers
134 views
Capturing datetime of change in SQL Server CDC
So we've started exploring using change data capture on one of our production databases. We'd like to know the datetime of each change. Reading through walkthrough's and tutorials etc it seems that ...
4
votes
1answer
106 views
In Change Data Capture (CDC), why lsn is used instead of timestamp?
I am learning to use CDC in SQL server 2008, I have read that LSN is always incremented and is based upon timestamp, so why LSN is required, if it is calculated from timestamp which can be used as ...
3
votes
2answers
242 views
Can CDC or Change Tracking be implemented against a SQL Server 2012 AlwaysOn read only secondary?
We will be deploying SQL Server 2012 AlwaysOn with read only secondaries and would like to execute our SSIS extracts against the secondary while utilizing CDC or change tracking (the decision hasn't ...
3
votes
1answer
376 views
Change data capture - how to know who made the change?
Tracking who made the change identified by CDC.
Along the lines of my datetime hack I tried the same approach by adding suser_sname as a new field with default value on the cdc change track table. ...
2
votes
1answer
278 views
In Change Data Capture (CDC), how to configure retention with success?
We have CDC enabled on SQL Server 2008 with retention re-configured to a number other than the default 3 days (or something similar).
When we first configured it (with default options), it worked ...
1
vote
2answers
203 views
Change Data Capture and the __$update_mask binary
We're using CDC to capture changes made to a production table. The changed rows are being exported out to a data warehouse (informatica). I know that the __$update_mask column stores what columns ...
1
vote
2answers
46 views
Can we Configure Change Data Capture in another Database?
I want to apply Change Data Capture(CDC) to database DB1's tables and want to log everything in DB2.
So, could it be possible to capture table DB1's changes to DB2?
1
vote
0answers
123 views
Configuring SQL Server 2008 R2 Change Data Capture with SSAS
I'm completely new to SQL Server Analysis Servers (SSAS) so you'll have to excuse my ignorance. I've been running through the MSDN SSAS tutorial get a handle on how to use SSAS.
We have SQL Server ...
0
votes
2answers
33 views
Can I recover CDC tables from transaction logs?
Is there anyway to restore CDC tables from transaction logs? My basic understanding is that CDC reads these logs, and entries that are specially marked, are grabbed by CDC. Once this has happened ...
0
votes
0answers
68 views
Oracle Change Data Control - how to use SOURCE_COLMAP$ and TARGET_COLMAP$
Has anyone successfully used the TARGET_COLMAP$ column in Oracle Change Data Control to identify which columns have changed? I'm trying to produce audit reports for users and identify for the user ...
