What are the challenges you face when working across database platforms? Take the survey

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 ?



  • Options
    ducmanducman Posts: 26 Bronze 2
    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.