Hello all,
I am setting up a transactional replication job between two servers and I am trying to find out if it is possible to filter my publication when I create the snapshot and then remove the filters without needing to re-initialize the subscription.
My publisher has about 7 years worth of data in 6 large tables and I would like to filter these tables to 1 year of data for my initial snapshot so that it initializes quickly but then have subsequent transactions ignore the filter to optimize performance of the log reader agent. According to the documentation, if I remove the filter on the publication, the subscription must be re-initialized which defeats the purpose of what I am trying to do. Is there any way around this?