how to send partial data to subscriber from publisher using .net

[Guest]

Hi all,
I am doing a pocket pc application with vb.net and sql server , i am able to
synchronize the sql server with pocket pc using merge replication and
everything is working fine like creation database in pocket pc and accessing
database . But my question is how i can send only partial data to different
subscribers. As with merge replication it sends whole data to subscriber. I
want to do this with .net application not with sql server where while
creating merge replication we define filters for data i dont want that why,
Is there any way to do with vb.net or c# for filtering data for subscribers .

 

[Guest]

Row filtering should be done at the server. Replication doesn't allow a
subscriber to just get "part" of the data (well not without a
disconnection). If you want to do horizontal filtering at the client then
use a mechanism that's designed for it, like RDA.

-Chris

 

[Guest]

Hi tacke ,

I dont know much about RDA . I want to know that can we write in
application for the clients to update only partial data using RDA in vb.net
or c# . If so, can you suggest how to do RDA and books or any online
resources or links that you know . How to configure RDA for vb.net or c#

you are saying that we cannot get "partial data" a

 

[Chris Tacke, eMVP]

Replication uses a subscription model which is a good analogy. Let's say
you subscribe to a magazine. You can't ask the publisher to only send you
certain articles you want - you get the whole thing, then decide after you
get the publication which parts you're interested in. You're free to look
at whatever you want whenever you want without the publisher caring.

Now if you want to only get certain parts, then it requires interaction.
This would be like the magazine's web site. You can get articles as long as
you are connected to the publisher. If you get one article then disconnect,
and it turns out you want anothyer then you must reconnect. This is
analogous to RDA. There are plenty of tutorials for both on the web, but I
think you need to think about the design before jumping into it.

--
Chris Tacke
Co-founder
OpenNETCF.org
Are you using the SDF? Let's do a case study.
Email us at d c s @ o p e n n e t c f . c o m
http://www.opennetcf.org/donate