Exclude cdc functions?
markoos120
Posts: 3 New member
Trying to get setup with our first SCA project. The baseline script has explicit create function statements for change data capture (cdc) functions for cdc-enabled tables, but explicit creation of cdc objects is not supported in SQL.
Is there a way to have SCA ignore the cdc schema functions, and instead properly "enable" cdc on the affected tables? i.e. sys.sp_cdc_enable_table ?
Thanks
Is there a way to have SCA ignore the cdc schema functions, and instead properly "enable" cdc on the affected tables? i.e. sys.sp_cdc_enable_table ?
Thanks
Answers
The "enable" cdc on the affected tables, if SCA is not already doing that for you, then you may have to manually write a migration scripts to do that.