Options

Exclude cdc functions?

markoos120markoos120 Posts: 3 New member
in SQL Change Automation
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
· Share on Twitter

Answers

  • 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.
    · Share on Twitter
Sign In or Register to comment.