InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 17:48:30 GMT20http://www.sqlservercentral.com/Forums/Topic1365321-291-1.aspxThere 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,chrismssqlconsulting.comThu, 06 Dec 2012 17:39:48 GMTChris Beckerhttp://www.sqlservercentral.com/Forums/Topic1365321-291-1.aspxThis doesn't look like a situation where I would use replication. You may be better off setting up SSIS packages to transfer the data that you need.Tue, 23 Oct 2012 03:31:16 GMTirobertsonhttp://www.sqlservercentral.com/Forums/Topic1365321-291-1.aspxWe are planning to have a reporting server where data is replicated using transactional replication from production server. If I plan to disable deletes to the subsciber.Can weuse the subscriber databse for archival purposes also? Would creating a snapshot be an issue? Can the subscriber database have more data than publisher?Any input is greatly apprecited.ThanksThu, 27 Sep 2012 08:50:58 GMTreddyk