I want some way of doing replication in which only inserted and updated data gets replicated not the deleted one.
The idea is to build archiving database from the live db. but we want live db to be small.
1- Move changed data from live db to archive db
2- delete data from live db of older than today
we have to implement this in sql server. any other solution than replication.