SQL Server CDC (Change Data Capture)

  • 1
  • 1
  • Idea
  • Updated 2 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 2 months ago

  • 1
  • 1
Photo of Neal Stack

Neal Stack, Employee

  • 3,302 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


Photo of Alfredo Cerrillo

Alfredo Cerrillo

  • 224 Points 100 badge 2x thumb
Thanks for your prompt reply, Neal.  There is a way to keep track of this feature request?
(Edited)
Photo of Neal Stack

Neal Stack, Employee

  • 3,302 Points 3k badge 2x thumb
Hi Alfredo,

Unfortunately, we do not have a publicly accessible bug/new feature database.

You could monitor the Release Notes for each new release, periodically log a support case to check on the status or speak to your account rep to express the urgency of the feature.

Our product management team also monitors requests and may possibly reach out.

Thanks,
  Neal