Exclude cdc functions?

markoos120

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

ducman

You can definitely ignore anything that's apart of a schema using filters. 

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.