Replication between 2 DBS

[KeyserSoze1877]

How do I set up replication between two databases so that all new information will be published to the subscriber, but if i delete from the publisher not to delete that information from the subscriber. The subscriber will be an archive, I do not want to delete records from that at all.

How do I go about this?

 

[AshleyRickards]

only way I can think to do would be to remove delete rights at the Sub. on all the tables. Possibly there is a way to modify the Agent. I've never had to do this, but it might work. Ashley L Rickards
SQL DBA

 

[grahamm]

You don't say what kind of replication you have set up. However from your problem description I'm assuming transactional replication. A solution is to define custom resolution procedures for update and delete that do nothing.
Look under "Using Custom Stored Procedures in Articles" in SQL Books online. The issue you face though is that you'll have to alter the archive database to remove any primary key constraints and possibly add date time stamps for each record