Filter via header/detail relationship?

#1

you should set up the article defaults so that the include
DRI table default is set.

Quote:

-----Original Message-----
(Doing Merge replication, Subscriber pulls, SQL2000sp3a,
clients as slow as 33k dialup through Symantec VPN)

Let's say I set up an OrderHeader table with (in addition
to the replication column(s) OrderID and SalespersonID,
and another table called OrderDetail with OrderID,
ItemID, and Qty. So far, so good.

Next I set up a FK relationship such that
OrderDetail.OrderID must exist in OrderHeader.OrderID.
Simple enough.

Now let's say I publish the two tables for replication,
and I set up a dynamic filter on OrderHeader using
SUSER_SNAME() = OrderHeader.SalespersonID. I do not set
up any filters for OrderDetail, on the theory that the
relationship will take care of filtering.

Am I correct?

If not, is there a way to do something similar, ie filter
a single top-level table rather than setting individual
filters for sub tables whose very data by nature is
limited by the FK relationship?

.

#2

Hillary Cotter wrote:

Quote:

-----Original Message-----
you should set up the article defaults so that the

include DRI table default is set.

Quote:

-----Original Message-----

Didn't understand your response, but am eager to do so
and very much appreciate it in any case. Can you be more
verbose and not use abbreviations?

(I'm a developer, but a SQL replication noob.)

#3

when you are creating your publication you get to a dialog
called specify articles. Click on the article defaults.
Select table articles (you might not see this option) Then
go to the snapshot tab. In the Copy Objects to the
destination check include DRI.

Continue as per normal.

Quote:

-----Original Message-----
Hillary Cotter wrote:
-----Original Message-----
you should set up the article defaults so that the
include DRI table default is set.
-----Original Message-----

Didn't understand your response, but am eager to do so
and very much appreciate it in any case. Can you be more
verbose and not use abbreviations?

(I'm a developer, but a SQL replication noob.)
.

#4

Yes it does!
"Tom Jackson" <tomja (AT) bryanequipment (DOT) com> wrote

Quote:

Hillary Cotter wrote:
-----Original Message-----
when you are creating your publication you get to a
dialog called specify articles. Click on the article
defaults. Select table articles (you might not see this
option) Then go to the snapshot tab. In the Copy Objects
to the destination check include DRI.
-----Original Message-----

Got it, see it, did it. Cool :-)

DRI = Database referential integrity?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Filter via header/detail relationship?

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication

Filter via header/detail relationship? - 07-15-2003 , 11:13 AM

Filter via header/detail relationship? - 07-15-2003 , 11:47 AM

Filter via header/detail relationship? - 07-15-2003 , 02:28 PM

Re: Filter via header/detail relationship? - 07-15-2003 , 08:01 PM