Post reply

Change Data Capture

  • January 28, 2015 at 7:56 pm

    #294281

    Hi All,

    I am trying to use change data capture to load the data into the secondtable from table 1 which is coming from UI. What will be the minimum latency??? Can we use incase of latency less than 5 seconds.

  • January 29, 2015 at 12:52 am

    #1773899

    CDC only records changes, it won't push them into your second table.

    You have to write the ETL yourself, but 5 seconds is quite low so you would need to write some pretty fast scripts.

    Maybe you can look at other options, such as replication.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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