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 |
|
pagan1234
Starting Member
7 Posts |
 Posted - 2012-07-02 : 15:41:34
|
| Hello everyone, Not sure if anyone had to deal with this scenario like mine but hopefully someone can help.Here is my situation..We are planning to implement a process which will push real time data changes from our 3rd party vendor. The one option I’m interested in is enabling CDC at 3rd party site and replicate changes only to our site. In this setup we basically get a copy of the database from vendor so we will have a baseline and from that point on, we will need to only load changes into our site. I’ve tried CDC and it works great but with one caveat, It won’t allow me to replicate system tables in CDC schema (%%%%_CT) where all changes are saved. Can someone please put me in the right direction? TIA |
|
|
|
|
|
Can CDC and replication coexist?