Conditional MS SQL replication I have an issue that I want to do conditional replication to one of my enterprise level client databases. This database is very large: approximately 300 GB MDF file and a 160 GB LDF file because of archiving and accountability. 

My primary DB has lots of accountability data and I want to transfer them to the secondary replicated DB for reference purposes. Once the accountability data has been deleted by a job on the primary server, when the replication job runs again 
the secondary DB should retain all the accountability data without overwriting and/or deleting anything. 

Does anybody have a suggestion on the best way to do this?
Reference:


Transactional Articles - Specify How Changes Are Propagated
sp_addarticle (Transact-SQL)
Transactional Replication insert only new Records


Yes it is possible with transactional replication.  I am assuming initially you want all data to be replicated to secondary. For that you will do a reinitialize and snapshot. From there on if your article is set up I mentioned below only new inserts will be replicated. For update you can do the same if you chose to.

When using sp_addarticle set @del_cmd  value to NONE.

If you do it from GUI it will look something like this.