1

I have a project, which involves using Sql Server 2012 Standard Edition. This project needs to have Sql Server Change Data Capture enabled (CDC). Is CDC available in Sql Server Standard Edition?

Eugene Goldberg
  • 14,286
  • 20
  • 94
  • 167

2 Answers2

5

If you try to enable it on standard, you should get an error message along these lines:

Change data capture is only available in the Enterprise, Developer, and Enterprise Evaluation editions

And here is a more definitive link: https://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx

snow_FFFFFF
  • 3,235
  • 17
  • 29
0

CDC is available only in Enterprise Edition, but you can use Change Tracking in Standard edition:

https://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx

You can check your requirements in such a way that you can accomplish only using CT

Kannan Kandasamy
  • 13,405
  • 3
  • 25
  • 38