Home > database >  Is essentially the CDC and publish subscribe with open, change data capture is less than CT table
Is essentially the CDC and publish subscribe with open, change data capture is less than CT table

Time:09-16

Hello, everyone:
On SQLServer2014 has already started the release subscription function, then because of the screening problem need to enable the function of database, the CDC and enabled a form to track data changes to the CDC, the configuration is completed, I manually update the table row data, CT found no trace to any data in the table, but I am not used previously in another release subscription database enabled on the CDC can normal tracking changes to the data, at the same time, please enable release subscription and the CDC's scenario, how to configure to track the changes to the data? Thank you first!

CodePudding user response:

I also met this problem, there is a solution yet

CodePudding user response:

^_^, also want to ask you the answer, find out after five minutes, you should be no open used engine
Open means as follows: a lot of online said the CDC, didn't mention about the engine start to ask
https://blog.csdn.net/u011511684/article/details/24475497

CodePudding user response:

Excuse me, would you please tell me how to find a solution, I also open the SQL agent, the CDC's homework has not generated, a relationship with this and publish subscribe
  • Related