SQL Server replication without deletes?

Question

Is there a way to replicate a sql server database but not push out deletes to the subscribers?

Answer 1

Do this....Drop the article. Create a new storedprocedure in the corresponding database that mimicks the system store procedure (sp_del...) and contains the same parameter but does nothing. Add the article again...and set the delete store procedure under the article's properties to the new delete stored procedure that you created....

Or you can select Do not replicate Delete Statements....I think that works but i haven't tried it.

Answer 2

You don't mention which version of SQL Server you're running, but Andy Warren wrote an article on configuring INSERT, UPDATE, and DELETE behaviour in SQL Server 2005. You can configure this through the GUI, using his instructions:

http://www.sqlservercentral.com/articles/Replication/3202/