April 3, 2014 at 8:43 pm
Because CDC is available in 2008 R2 and 2012, it would be an ideal solution to my need to keep my reporting/Data warehouse database always refreshed with real-time data.
Is the secondary database accessible, readable?
Does anyone know if CDC is a viable option for updating a reporting database? I love the fact that it even replicates DDL changes.
Thanks for your ideas. Jack
April 4, 2014 at 12:45 am
Yes, the secondary database is always accessible and readable.
You have to transfer the CDC change rows yourself though. SSIS 2012 has special components that help you with this.
Are you sure it replicates DDL changes? It is called "change data capture".
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 4, 2014 at 3:03 am
Yes, CDC can be used to update DW database. Refer following doc
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply