Competition: What’s your favorite Redgate tool? Enter now.

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 ?

Thanks

Answers

  • ducmanducman Posts: 18 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.