We are installing a solution to dynamically replicate all 'insert' and 'update' rows from our 'Production Server' to the 'Archive|History Server';
Our goal is to eliminate the actual 'By Night' Batch Operations.
Three tables on three different Databases are affected by that operation.
On each archiving Database (Replicate), the Tables Definitions are a little different...
For each, we have create a Replication Definition and a Subscription.
Because it is an Archiving Solution, any 'delete row' on Primary Tables should absolutely never be replicated.
We did not find how to replicate just 'insert|update rows' ???