Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Partial Replication problem


Message #1 by "Steven White" <Steve.White@m...> on Mon, 29 Jul 2002 23:05:21
I'm having a bit of a replication problem, 

I have 2 fields which I want to drive the whole replication process.
HOSC and VST

I have heaps of different replicas based on HOSC, that is to say a 
partial replica with a filter of HOSC=128, a different one of HOSC=7 and 
so on.

That bit works fine. However, I want it so that it does a one way synch 
with the design master, but I want it so that the design master only 
contains those with a value of VST=1.

The different replicas can have VST=0, VST=9 and VST=99, but I only want 
to synch records where VST=1

I don't really want to have another replica where the filter is VST=1, 
and the design master contains all values of HOSC and all values of VST.

Not too sure if I explained this well, so I'll give you an example 
relating to the design master and a partial replica where HOSC=128:

Record1: VST=1, HOSC=128 (Gets put in partial replica and design master)
Record2: VST=1, HOSC=34 (Only in the design master)
Record3: VST=0, HOSC=128 (Only in the partial replica)
Record4: VST=0, HOSC=34 (In neither of these files)

Can someone help me out with this?

TIA

Steven

  Return to Index