dcsimg
Results 1 to 3 of 3

Thread: Replication and CDC working together?

  1. #1
    Join Date
    Jul 2010
    Posts
    2

    Replication and CDC working together?

    Hi

    Has anyone faced any issues having both replication and CDC enabled on same tables in the db on SQL Server 2008 environment?

    Want to know if there are any weird behavior in case both being working together as there are underlying processes and objects being same.

    Thanks

    Mahesh

  2. #2
    Join Date
    Jan 2010
    Posts
    37
    I have never heard of anything like that, but that is interesting. What kind of issues are you facing? And why do you think it is related to CDC/replication being one the same tables?

    I would not think that there would be an issue unless you are having CDC perform data inserts/updates/deletes from the same tables that are in replication as a result of a particular change.

    In that scenario depending on how CDC and replication are setup I could see potential setups that could cause continuous data modifications, which would be an issue.

  3. #3
    Join Date
    Jul 2010
    Posts
    2
    I m not facing any issue as such...

    I m just checking out if anyone have any similar setup in their environment and have faced any issues having replication and CDC working together.

    Thanks

    Mahesh

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •