Merge Replication and Dynamic and Static Filtering

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.

>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?)
Yes, if you have server articles in the publication. There is only one row
filter for a specific article

> 2) Then before synchronizing, change the filter clause (through
SQLDMO)
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.
--
>From: "Maer" <maer@.auditleverage.com>
>Subject: Merge Replication and Dynamic and Static Filtering
>Date: Tue, 25 Oct 2005 23:45:31 -0400
>Lines: 38
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <uGguf9d2FHA.3228@.TK2MSFTNGP15.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: pcp08364781pcs.lndsd201.pa.comcast.net 68.42.19.117
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17361
>X-Tomcat-NG: microsoft.public.sqlserver.replication
> 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
>
>
|||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@.online.microsoft.com> wrote in message
news:ev98V7t2FHA.1144@.TK2MSFTNGXA01.phx.gbl...
> 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
> SQLDMO)
> 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.
>
> --
> When
> the
>
|||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.
--
>From: "Maer" <maer@.auditleverage.com>
>References: <uGguf9d2FHA.3228@.TK2MSFTNGP15.phx.gbl>
<ev98V7t2FHA.1144@.TK2MSFTNGXA01.phx.gbl>
>Subject: Re: Merge Replication and Dynamic and Static Filtering
>Date: Thu, 27 Oct 2005 11:58:29 -0400
>Lines: 106
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>Message-ID: <#qciv7w2FHA.2292@.tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.replication
>NNTP-Posting-Host: pcp08364781pcs.lndsd201.pa.comcast.net 68.42.19.117
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msft ngp13.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.replication:17417
>X-Tomcat-NG: microsoft.public.sqlserver.replication
> Thank you, Peter. This answers my questions It also shows that the
>approach of dynamically changing the filter before synchronization will
not[vbcol=seagreen]
>work.
> Thank you,
> Maer
>
>"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
>news:ev98V7t2FHA.1144@.TK2MSFTNGXA01.phx.gbl...
or[vbcol=seagreen]
filter,[vbcol=seagreen]
row[vbcol=seagreen]
for[vbcol=seagreen]
to[vbcol=seagreen]
to
>
>