Friday, March 23, 2012

Replication Question

I set up a transactional push replication and basically
would like to use the subscriber as the archived
historical database server.
Once the snapshot is completed, I would like to delete
old records on the publisher article and not replicate
the deletion onto the archive database
server. How do you do this once the replication is set
between the publisher and subscriber?
TIA.
Thank you.
>--Original Message--
>On the article properties for the particular table(s)
you
>want to stop the deletes, on the commands tab write NONE
>for the propagation of delete commands.
>Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>.
>

No comments:

Post a Comment