Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2014-03-05 : 14:25:03
|
| I would like to get the opinion of people who are using CDC to keep a secondary database in-sync for reporting or data warehouse purposes.When mirroring was released for 2005, I was impressed with how easy it was to configure and it worked very reliably. Hopefully CDC is the same.Thanks, John |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-03-05 : 14:30:40
|
| Normally transactional replication is used to keep a secondary database in-sync. That's what we used in previous version, but we are now using AlwaysOn readable secondary feature since our schema is the same as the OLTP database.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2014-03-05 : 18:10:20
|
| Yes, I would love to use the AlwaysOn feature but my source/primary instance is 2008 R2 and AlwaysOn isn't available for pre-2012.So I'm going to give CDC a whirl and I'll post back with how well it works.Thanks |
|
|
|
|
|
|
Are you using CDC Change Data Capture?