October 30, 2003 at 12:55 pm
I have a transactional publication setup with horizontal filters that filter out data over 60 days old. At the time of the snapshot only data within the last 60 days will be replicated, but that becomes a sliding date. As new data is entered, it is replicated to the subscriber database, but the old will still be there. Do horizontal filters only apply to inserts or do they apply to updates as well? In other words, a record is replicated on 10/1 as a new insert. It is updated periodically over the next 60 days. After 60 days has expired, will updates continue to be applied to the row. If not, what are the ramifications of deleting the expired data from the subscriber database.
November 3, 2003 at 8:00 am
This was removed by the editor as SPAM
November 4, 2003 at 9:04 am
Hi,
As far as I know the filter applies to updates. deletes and inserts. One thing I would caution against is transactional rep with records that change qualification status. I've had no end of problems with it. In your case, post-distribution, you should be ok to cleanup the subscriber for anything that is older than 60 days from systemdate by running a script to pick up stragglers. How big is the dataset?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply