Hi techies
I have set up a Transaction replication from My Primary Server to
Secondary Server on Orders table.
Thousand of records gets inserted on Orders every hour which get
replicated on the secondary server. it works fine
reporting apps uses Secondory server's Orders table data for generating
reports .
The Problem :
Let say if i want to Remove older records from Orders table in the
primary serverwith out reflecting this change on the secondary server.
is there a way to PREVENT this operation /transaction to be propogated
to the secondary server.
Note : i am moving the records to another table (orders_Archive ) and
deleteing the rows from orders table . Also I need all the rows to be
present on the secondary server table.
Please advice ASAP
Regards,
Raj