October 13, 2013 at 8:17 pm
Hello DBAs!
Am facing the problem when I adding or altering the columns in source table.. its not getting reflected in cdc that corresponding table automatically... but previous months it was working fine.. but I could not see any error logs..
I would like to know why this ddl changes are not get reflected in cdc table?
Is there any root cause..plz let me know you suggestions 🙂
Thanks in advance
October 14, 2013 at 6:57 am
Works as intended.
An added column will not be included in an existing cdc table.
A deleted column will result in NULL in the corresponding column in cdc.
Only solution is to create a second cdc on that table (mind you: max 2 cdc per table)
October 15, 2013 at 7:18 am
But without creating one more instance, previously it added the new column in to CDC tables.. how it was? I cant digest the behavior of CDC?
October 15, 2013 at 7:27 am
Saravanan_tvr (10/15/2013)
But without creating one more instance, previously it added the new column in to CDC tables.. how it was? I cant digest the behavior of CDC?
When you remember how you succeeded in doing so, please post it here. As far as I know it is not possible (but if it is, I like to learn).
October 15, 2013 at 9:32 pm
Yes I digged previois year history of ddl changes in source table.. that they did not added newinstance or disable and enable technique... but now I cant reproduce it....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply