Data Replication 2
Results 1 to 3 of 3

Thread: Ommit delete operation from replication

  1. #1
    Domenm is offline Junior Member
    Join Date
    Jan 2019
    Posts
    7
    Rep Power
    0

    Ommit delete operation from replication

    Hello,
    We are currently testing Attunity Replicate with SQL Server. Is there a way to configure Attunity Replicate not to replicate DELETE operations from source?
    I found an option to set this inside articles settings of MS Replication publication, but is it possible to set it on Attunity Replicate?

    Thanks for answers,
    Regards,
    Domen

  2. #2
    Hein is offline Senior Member
    Join Date
    Dec 2007
    Location
    Nashua, NH - USA.
    Posts
    151
    Rep Power
    12
    Two ways to deal with that.

    Look at (per table) TRANSFORMATION

    - Filter : Using Header Data Column AR_H_OPERATION

    - Convert to Update : Using 'operation_indicator' function to add a column with a deleted flag for a virtual delete.

    Hein.

  3. #3
    Domenm is offline Junior Member
    Join Date
    Jan 2019
    Posts
    7
    Rep Power
    0
    Quote Originally Posted by Hein View Post
    Two ways to deal with that.

    Look at (per table) TRANSFORMATION

    - Filter : Using Header Data Column AR_H_OPERATION

    - Convert to Update : Using 'operation_indicator' function to add a column with a deleted flag for a virtual delete.

    Hein.
    Hello Hein,
    thanks for your reply.
    I tried to use the first option you suggested ( Filter : Using Header Data Column AR_H_OPERATION ), but I'm afraid I don't know how to use this feature. Can you, please give me an example how to properly put AR_H_OPERATION inside filter condition.

    Thank you very much.
    Regards,
    Domen

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •