Skip to content
← SQL Compare

How can we improve SQL Compare?

SQL Compare

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Allow Comparison of CDC Objects

CDC (Change Data Capture) objects are currently excluded from comparison.

Because SQL Source Control uses SQL Compare behind the scenes, this means that CDC objects cannot be committed to source control, which in turn means that databases containing objects (e.g. views) which reference CDC objects cannot be deployed with SQL CI.

I don't believe that SQL Compare should compare CDC objects by default, but there should be an option to allow it.

28 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Matt Connolly shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    Just to add a comment that when a cdc table is changed there must be a snippet to copy past cdc data to a temp table. Stop CDC for this table. Add the fields, Enable CDC, reinsert temp table data into the new CDC table.