SQL Server CDC (Change Data Capture)

  • 1
  • 1
  • Idea
  • Updated 4 months ago
  • Under Consideration
  • (Edited)
SQL Sever has a functionality called Change Data Capture, wich allows to keep track of changes made to data (like an automatic log for every change).
When a restore is performed, CDC data isn't restored by default, it is neccesary to add the KEEP_CDC parameter to the RESTORE command to include CDC bits https://devjef.wordpress.com/2014/11/18/restoring-or-moving-a-database-with-cdc-enabled/.
There is a way to pass additional parameters to Delphix RESTORE process?
Photo of Alfredo Cerrillo

Alfredo Cerrillo

  • 224 Points 100 badge 2x thumb

Posted 4 months ago

  • 1
  • 1
Photo of Neal Stack

Neal Stack, Employee

  • 3,502 Points 3k badge 2x thumb
Official Response
Hi Alfredo,

No, unfortunately not at this time. We do have a feature request that would add support for CDC:
  • IDEA-1183 - Propagate CDC data from the dSource into the provisioned VDB
This feature request would change the syntax to "RESTORE ... WITH RECOVERY, KEEP_CDC" so that SQL Server does not perform the cleanup and would allow customer's to enable CDC again (manually or via a post-provisioning script) by creating the relevant CDC SQL Server Agent jobs as per https://msdn.microsoft.com/en-us/library/bb510626.aspx.

I've associated your company with this new feature request. Engineering has not accepted it so I cannot provide any type of ETA.

Thanks,
  Neal