When I create a new deployment package by right clicking the database in SSMS and select 'Publish [dbname] for Deployment', the package created doesn't include the CDC system tables.
- Code: Select all
2013-10-28 13:30:37 -04:00 DEBUG Creating [cdc].[fn_cdc_get_all_changes_dbo_TchApplicationRole]
2013-10-28 13:30:37 -04:00 ERROR Error while executing job: Create failed
Invalid object name 'cdc.dbo_TchApplicationRole_CT'.
As you can see above, it's attempting to create the CDC function, but since the function references the CDC tables that weren't created it fails.
How do I "fix" this?