Publisher:-SQL server 2012
Subscriber: - SQL Server 2008 R2 SP2
Some tables inside publication have row level filters defined.
Now whenever we want to change filter criteria for any table having filters, this always asking for re-initialization of the entire publication for all the tables in that publication. This will take significant time to generate snapshot and then to have all table reinitialized.
We want to understand if there is anyway in SQL server that we can modify filter for a table without reinitializing all the tables at the subscriber end? We would like only impacted table (where filter criteria is changed) to get refreshed at the subscriber end).