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