Feature support of SQL Agent job running SQL Server Integration Services package with CDC task

Question

We are trying to setup a SQL Agent which runs a SQL Server Integration Services package that makes use of a CDC Source Data Flow task.

When running the job, we get an error saying that Enterprise Edition is required:

Looking at documentation, we found that Change Data Capture components have support only for SQL Server Enterprise:

https://learn.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server?view=sql-server-ver16#ISAT

We have done a test and deployed the same package to a SQL Server 2019 Developer Edition and also a SQL Server 2016 Developer Edition, and the job is working fine.

Are Change Data Capture tasks supported in SQL Server Developer Edition or is there any kind of limitation? Just to confirm, are Change Data Capture tasks not supported in Standard Edition?

Thank you so much!

Regards,

Victor

Answer 1

SQL Server Developer Edition has exactly the same technical feature set as SQL Server Enterprise Edition. But there is a very important difference when it comes to licensing: Enterprise Edition (as well as Standard and Express Editions) are licensed for production. Developer Edition is not. So yes, there is a very important limitation.

Answer 2

Hi @Victor Rubio，

The documentation has mentioned that, for features supported by Evaluation and Developer editions, see features listed for Enterprise Edition in the following tables.

So, the component is supported in Developer edition.

is there any kind of limitation

The limitation is that the Developer edition cannot be used for production just for testing, developing, and learning purposes.

The Change Data Capture components by Attunity require Enterprise edition.

The Change Data Capture Service and the Change Data Capture Designer, however, do not require Enterprise edition. You can use the Designer and the Service on a computer where SSIS is not installed.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.