Exclude cdc functions?

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 ?



  • ducmanducman Posts: 17 Bronze 1
    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.
Sign In or Register to comment.