Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

CDC audit

hi all,

I heard that Idera compliance manager can't audit table that is part of replication and the before and after value can't be capture, is that right?

how about MS CDC?
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

I don't know idera compliance manager, but we use MS CDC and it does use the same underlying features as replication so we have to deal with everything as if we had replication turned on for the tables we have under CDC.
Avatar of marrowyung
marrowyung

ASKER

sorry, so it means if the table is under merge replication, it still auditable on who modify the record , when, by what  application, from which host and what is the queries modify that?
sorry I don;t know anything about the idera compliance manager to be able to answer your questions any better than what I provided about CDC behavior.
chris,


sorry, on vocation for the whole week.

you mean CDC can audit, and even provide before and after value for any table under merge replication?

any step by steps procedure on how to set it up?

any script to find out the existing configuration of CDC ?
ASKER CERTIFIED SOLUTION
Avatar of Chris Luttrell
Chris Luttrell
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"There is also Change Tracking which is described in one of the MS articles below,"

yes, one more feature since SQL 2008,

but are you sure CDC can audit table in merge replication? this is the most important part instead of how  to set it up.
Other than saying I have read that they will work together, I can't tell you a definitive answer since I do not use both.  Not much more I can do to help, you have tapped the extent of my experience.
ok. the only thing left is to try it myself by this sense.
chris,

"I can't tell you a definitive answer since I do not use both.  "

you mean you don't use CDC and Idera CM ?
yes, and I don't use CDC and replication.  we use CDC as part of our DW process, grabbing iterative updates to process hourly instead of daily.
"  we use CDC as part of our DW process, grabbing iterative updates to process hourly instead of daily."

hi,

so no merge replication here?
No I haven't used replication in production in about 10 years and then it was only Transactional replication.  I have not used them together.  I did research on Merge replication for another client since then but I did not do the install.
ok ok . the MS SQL server world is very hard by replication! A lot of thing can't be done. thoese talbe in replication can't put it RAM too.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
then I will setup CDC, I already have Idera CM setup but that one don't do good for table under merge replication.
I think  I need to study more on CDC then.
you know, even Idera will say sth B.S. about CM on table with merge  replication, it said it will be very slow but it doesn't mean it can't do that audit.

we can only audit few tables under merge replication but not all. then that's it.