Comparing CDC Enabled Tables

bgjohnso

Is it not possible to compare whether or not tables are enabled for CDC between databases?

Alex B

Hi @bgjohnso,

In the usual sense of comparing one database to another, this would not show up as a difference as it's an option held in sys.databases (the is_cdc_enabled column) and so this is not a part of the database itself.

It may be possible to use SQL Data Compare to compare one sys.databases to another on another SQ: instance as it's the data of the sys.databases table that is determining whether this is enabled, but for two databases on the same instance it wouldn't be possible as it's different rows in the same table.

This SQL Compare Uservoice suggestion is for allowing the comparison of CDC objects: https://redgate.uservoice.com/forums/141379-sql-compare/suggestions/7191259-allow-comparison-of-cdc-objects so you should vote on that and add a comment to clarify your use case!

Kind regards,
Alex