There is a feature called 'deferred update' in that an update to a column in a clustered index will replicate as a delete/insert pair.

Build an archive routine that moves rows out of 1 db to another arc db.

regards,

chris

mssqlconsulting.com