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

Comparing CDC Enabled Tables

bgjohnsobgjohnso Posts: 2 New member
Is it not possible to compare whether or not tables are enabled for CDC between databases?

Best Answer

  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    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,
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.