Post reply

Change data capture and transactional replication

  • November 7, 2011 at 5:16 pm

    #245696

    Hi all,

    I am planning to implement CDC which should be enabled on the subscriber db.

    i am currently doing my research on how to setup and was wondering if it's possible to setup CDC on the subscriber.

    If anyone doing the same setup can you please share with me on what will happen for example if i need to reinitialize the subscriber? Is there anything else there that i need to know about cdc and replication?

    Thanks

  • July 19, 2012 at 6:27 am

    #1514788

    not tried your method but as cdc is pretty new to sql id prob stick with an older method:

    triggers on change tracked tables that write change data to seperate local DB and then replicate the Change DB seperatly especially if you only want the changes at the destination!

    Regards

Viewing 2 posts - 1 through 1 (of 1 total)

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