This project is read-only.

Could CDC using on Database Mirror?

Dec 8, 2012 at 11:20 AM

I want to do ETL by SSIS on sql server 2008 r2 standard version.

But I consider HA on OLTP by using database mirroring.

I think the most important point is how 

"SQL Agent job purging data on defined schedule" install on Mirror server.

While auto-failover occur, StandardCDC will correctly run on two server(principal and mirror)?

And then SSIS fetchs the currently data from online database.