Post reply

Difference between CDC and tran replication

  • February 29, 2012 at 11:12 am

    #252363

    Hi everyone,

    I was asked such a strange question on an interview and could not answer it : what is the difference between CDC (change data capture) and transactional repllication?

    Thanks

  • March 3, 2012 at 1:17 am

    #1454420

    Replication will create a backup of Source table(s) into Destination Table(s).

    So inserts/updates/Deletes to data in source table will result in inserts/updates/Deletes in destination table. Data in Destination table will be exact copy of Source.

    CDC is more for audit. Data from Destination tables will not be deleted.

    Any inserts/updates/Deletes to data in source table will result in inserts to destination table with indicator specifying whether operation in Source table was insert, update or delete!

  • March 3, 2012 at 2:07 am

    #1454423

    replication and cdc are totally different.Replication is used to populate the data from one database to other the database. But in CDC it captures both old and new data and this can be used for auditing purpose.

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

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