Hi All,
Is it possible to replicate only INSERTS and UPDATES and NOT Deletes.
We have a production server and reporting server. The challenge is to keep
90days of data in the production system, and 180days of data on the
reporting system. Need to some how to ensure that the cleanups done on the
Production server are not propogated through to the Reporting server.
Really appreciate it if someone can point me in the right direction - I am
sure this problem has been solved before.
thanks
Mathew
If you're using transactional replication, on the article properties,
commands tab, enter NONE for the delete command. if it's merge, there isn't
a straightforward method, but provided you understand the ramifications, you
could disable the merge delete trigger.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment