Remove data from Publisher after replication

Hi folks,

Currently, transactional replication with updatable subscription is configured on our web application so that data will be replicated from "external" DB to "internal" DB and vice versa. We are now thinking whether it is possible to remove the data from the "external" DB as much as possible to reduce the rick of being hacked and lost sensitive data from it. Is there any option in replication can achieve this? Or should it be done in a way other than replication?

Thanks in advance. :)

Kenneth

When the table is replicated like this case, deleting rows on one side will be replicated to the other side (means delete on both side). Two-way replication is not good choice if you want table holds different rowset on each side.

You are right Rmiao, that's the problem that need to be tackled. Simply speakly, we need to remove data from "external DB" after replicating to "internal DB".