How can we help you today? How can we help you today?

Change Data Capture (CDC)

Hi,

Is there any way to get SQL Compare to recognize CDC objects?

This is related to SQL Source Control and SQL CI, which use SQL Compare behind the scenes. I have a database with views which reference cdc objects. These are causing the SQL CI build to fail with an "invalid object name" exception, because the cdc objects themselves are not getting built. They aren't included in the build because SQL Source Control ignores them - which in turn is because SQL Compare ignores them.

This behaviour doesn't seem to be configurable in the SQL Compare options...

Can anyone help?

Cheers,

Matt
Matt Connolly
0

Comments

2 comments

Sort by
  • Chris.Allen
    Hi, thanks for your question.

    Support for CDC is now in our list of features to support for the future.

    I can't give dates at this point.
    Chris.Allen
    0
  • scanner2001
    We are having the same issue. How did you resolve this?
    I don't seem to be able to get the migration scripts to work. I have tried migration scripts to create the cdc setup/enable for the tables, then create the views, but it never runs the cdc part of the script.
    scanner2001
    0

Add comment

Please sign in to leave a comment.