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

  • Alex BAlex B Posts: 1,118 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: 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.