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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy