SQL Server source limitations Replication of table without primary key

[MoeE]

Hi guys.

I saw in the SQL server source endpoint limitations "If your database is not set up for MS-REPLICATION or MS-CDC, you can still capture tables that do not have a Primary Key, but bear in mind that in such a setup only INSERT/DELETE DML events will be captured. UPDATE events will be ignored" 

I tested this with neither MS-REPLICATION nor MS-CDC enabled and a table with no PK but the task failed with the error "The MS SQL Server instance is not set up for Replication".

So is that limitation wrong or am I missing something? It seems that when both MS-REPLICATION and MS-CDC are not enabled then even full load won't work. Also when MS-REPLICATION only is enabled then this rule seems true. Can I please get some assistance on this?

Thanks,

Mohammed

[john_wang]

Glad to hear that, @MoeE