Is it possible to setup partitioning on a SQL Server 2012 publisher table, so that older data can be removed without affecting the same table on a subscriber table?
Table exists on
Database A (SQL Server 2012 - app DB) to store a
varchar(max) field that is populated by a web app, and never referenced again. Table is replicated to
Database B (SQL Server 2012 - data mining DB) where it will be used for
Would like to partition table on both DBs by quarter and only have data from current quarter on Database A (Database B will have historical quarters).