CDC on secundairy replica

  • MSDN states the following on: Readable Secondary Replicas (AlwaysOn Availability Groups) for SQL Server 2014:

    Limitations and Restrictions:

    Change tracking and change data capture are not supported on secondary databases that belong to a readable secondary replica:

    Change tracking is explicitly disabled on secondary databases.

    Change data capture can be enabled on a secondary database, but this is not supported.

    This confuses me: You can not track the changes. However you can enable CDC?

    The scenario I am trying to achieve is to use SSIS CDC components on an asynchronous secondary replica. Is this possible? If not what would be other viable approaches?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply