SQL Replication

[lck092580]

Hi,

If I want to replication from a publisher to a subscriber and periodically delete records from the publisher but don't want the data to be deleted subscriber, what type of replication can I use? Basically what I want to do is have the subscriber as a respositor of data.

Thanks.

 

[NoCoolHandle]

That can't be done via replication. If you need to do this you will need to do it with dts or scheduled jobs that run on the "publisher", copy changes to the "subsrcibers" except never do the deletes...

HTH


Rob