没有删除的 SQL Server 复制? [英] SQL Server replication without deletes?

问题描述

有没有办法复制 sql server 数据库而不将删除推送给订阅者?

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

推荐答案

这样做....删除文章.在相应的数据库中创建一个新的存储过程，模拟系统存储过程 (sp_del...) 并包含相同的参数但不执行任何操作.再次添加文章...并将文章属性下的删除存储过程设置为您创建的新删除存储过程....

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.

这篇关于没有删除的 SQL Server 复制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！