Friday, March 9, 2012

Replication - Preventing data deletion

I have just started using data replication as a method of transferring data
from a temporary database to a central one. This works fine however I wanted
to be able to clear down the temporary database from time to time but not
surprisingly this deletes the corresponding records from the main database.
Is it possible to prevent the deletion of records from the publisher removing
the corresponding records in the subscriber? How about changing the Delete
command with a procedure that does nothing in the Table Article Properties?
Thanks,
Bill
You can either change the Delete to do nothing in the Table Article
properties or, if you are using the replication stored procedures, you can
alter the delete procedure at the subscriber to do nothing.
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment