Skip to Content
1
Former Member
Apr 25, 2013 at 02:28 PM

Replicating ASE to ASE for History Database excluding 'delete rows' on primary Site

85 Views

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' ???

šŸ˜¢