topic Re: SQL Server Transactional Replication - Updates Only in Qlik Replicate

SQL Server Transactional Replication - Updates Only

Praveen_Devaram — Wed, 14 Feb 2024 00:05:34 GMT

With native SQL Server transactional replication, you can turn off insert/udpate/delete in the article properties > statement delivery section.

Is there similar functionality with Qlik?

I'd like to create a task where it will only capture updates for a specific table.

Re: SQL Server Transactional Replication - Updates Only

Dana_Baldwin — Wed, 14 Feb 2024 00:18:30 GMT

Hi @Praveen_Devaram

This section in the user guide should help: Creating a record selection condition for one or more columns #Creating a record selection condition for one or more columns | Qlik Replicate Help

Re: SQL Server Transactional Replication - Updates Only

john_wang — Wed, 14 Feb 2024 01:26:24 GMT

Hello @Praveen_Devaram ,

@Dana_Baldwin 's solution works however I still want to understand further about the task design: if capture UPDATE only, then how about the INSERT records? if all the INSERT operations are ignored, the target UPDATE maybe failed as the INSERT row cannot replicated to target side, then the UPDATE operation cannot find the target row, unless the task set to UPSERT Mode, or Store Changes Mode. So far we still need replicate the INSERT and DELETE operations to make sure the data synchronization between source and target side.

Regards,
John.