Enabling CDC in SQL Server 2005 won’t work?

I am trying to use AWS replicate following this tutorial – https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.CDC.Publication .

Using this code on a 2005 Microsoft SQL table

exec msdb.dbo.rds_cdc_enable_db 'databasename';

Results in

Could not find stored procedure ‘msdb.dbo.rds_cdc_enable_db’.

This is the driver currently

MS SQL Server / SQL Server (Old driver, jTDS)

Any idea on how to overcome this issue?

Answer

CDC is not available in SQLServer 2005. It’s in 2008 onward (enterprise edition until 2016 SP1, where it’s also available in standard edition)