Replication of only updates and inserts
In the Article Properties, you can set the publication to not replicate deletes.
On the Article Properties page, just scroll down to Delete delivery format and change it to &quot;Do not replicate...&quot;
Note that if you're not replicating deletes, you risk a scenario where a row or update errors and causes issues. This will only happen if a deleted row has a value that is reused on the primary key or other unique constraint. If you're using an IDENTITY column for PK (and no other unique indexes on the replicated data), this would only happen only if the ID is reseeded or someone uses IDENTITY_INSERT. It's a more common problem to encounter when using a natural key. If you anticipate this being a problem, you can put instead of triggers on the replicated copy to convert inserts to upserts