Hi Guys - I have some basic questions about horizontal filtering and
would appreciate any help.

Dynimic Filtering

When I create a snapshot of a publication that has dynamic filtering,
what will it include? In other words, when the subscriber synchronizes for
the first time, will it apply the snapshot and then filter the data or is
the snapshot already filtered and, if so, by what (since filtering is
different for every subscriber)?

Static Filtering

If a subscriber gets data that is filtered by a particular region for
example, then you enter data in the subscriber for a different region. When
you synchonize, since the region information you entered is not part of the
filter, will it be deleted from the subscriber after it gets propagated to
the publisher or will it remain there?

My last question is if it is possible to do the following:

1) Create a static filter with several criteria (or is only one
allowed?)
2) Then before synchronizing, change the filter clause (through
SQLDMO)

If it seems like that if I change the filter clause then I have to
create another snapshot and reinitialize the subscriber.

Here is our situation, we would like for each subscriber to be able to
choose how they want to filter their data (some may want their data to be
filtered by more than one criteria). Is this flexibility possible?

Thanks,
Maer

Hello Maer,

Per your question, in Dynimic Filtering, when creating the subscription or
reinitilization the subscription, the snapshot will enable the dynamic
filtering. However, syncrhornization process itself will only syncronize
the data and does not have impact on snapshot. Anytime, you change filter,
you have to reinitilizae the replication.

Yes, if you have server articles in the publication. There is only one row
filter for a specific article


Again, you have to reinitialize the repliction after a filter is changed.

Thanks & Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------

Thank you, Peter. This answers my questions It also shows that the
approach of dynamically changing the filter before synchronization will not
work.

Thank you,
Maer


"Peter Yang [MSFT]" <petery (AT) online (DOT) microsoft.com> wrote

Hello Maer,

You are welcome! :-)

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------