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 |
|
Bortiquai
Starting Member
4 Posts |
 Posted - 2011-10-21 : 14:55:46
|
| I have transactional Replication Setup in a push style replication. On the Publisher database, I have Change Data Capture enabled for certain reporting processes.Occasionally, because of schema changes and other reasons, I need to reinitialize the subscriber. Right now, I am doing this from Snapshot. The problem is, when it re-creates the articles, the CDC settings are lost. And until CDC is re-enabled, the reporting processes that rely on CDC fail. Futhermore, any transactions that are replicated before CDC is enabled are essentially lost as far as the reporting processes are concerned, because those transactions never make it into the CDC tables.My idea is to stop the log reader agent so that it can not replicate transactions. Then Reinitialize the the subscriber, and enable CDC once synchronization is complete. Then, at that point, restart the log reader agent, so it will replicate all the transactions that took place while re-reinitialization was happening, and all is well.One issue i've already run into is that reinitialization from snapshot won't start while the log reader agent is stopped. Is there a way around this?Basically, what i need to happen:1) Replication and Reporting Processes are working just fine2) I stop transactional replication3) Make whatever changes I need to on the publisher database, and re-configure the publication as necessary4) Reinitialize the subscriber5) Enable CDC on the Subscriber6) Start transactional replication, so everything since step 2 is replayed, and everything is captured in the CDC tables5) Replication and Reporting Processes are working just fine againAny Ideas? Thanks,-Matt |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-09 : 10:58:46
|
| In the Table Article Properties, Destination Object tab, change from drop/create to either truncate or delete. |
 |
|
|
|
|
|
|
|
Stop Transactional Replication during/after Reinit