I have a database for an order handling system that is replicated to an other database.
The publisher and distributor database are the same.
I want to keep the publisher database small for performance reasons.
The subscriber database is used for reporting.
I want the delete statements that are executed by the user applications replicated to the subscriber database.
At night I want to run a stored procedure to clean up the publisher database. This involves deleting records from several table if they are older than x days.
These deletes (from the clean up job) I do not want to replicate to the subscriber database.
Is there are way to do this?
So if a user deletes an order from the system with his application then I want to mirror that delete to the subscriber database but if the order is deleted by a clean up job because it is shipped more than 60 days ago then I do not want to mirror that delete.