June 9, 2021 at 1:39 pm
hi guys,
does any one know how to replicate "only deleted records" using transactional replication ? in other words deleted record needs to be moved to other database using transactional replication
June 9, 2021 at 3:36 pm
I'm dumb as a rock, but wouldn't you do that with a delete trigger? Inside the trigger, you'd use the Deleted virtual table, and insert those records into some other table.
June 9, 2021 at 4:04 pm
What pietlinden noted is what I've done. What you are really doing here is auditing, so a trigger works well. From here, what you then do is replicate for some reason. We used this process when we had to update a third party product. We used a delete trigger to track the records. We then replicated this to another instance and another db. A process then read this table, updated another database with the change, and then marked the item in the replicated table as processed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply