Re: Newbie questions on merge replication, sql mobile 2005

Thanks Alberto,

I am not sure where to set the filter in pocket pc and how to change
host_name() in pocket pc, are there any details or walkthru available?

Thanks,

Luke
"Alberto Silva - Mobile Devices MVP"
<albertosilva@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A56CBB8-3D31-4EA4-82D6-2C7B53766E9E@xxxxxxxxxxxxxxxx
Hi,
About the 1st one, I have to check this myself, but you can create a rule
based on a field to filter the data to be synchronized. Something like,
let's suppose you create a field called bitUploaded with the Bit datatype,
and you set a filter to bitUploaded = 1. IIRC, inserting new records at
the device side with the bitUploaded set to 0, when you sync the inserted
records are uploaded to the server and removed from the PDA... try and let
us know how it went.

About setting a set of data according to the subscriber, you can set the
hostname property for each device to a unique string, like PDA01, PDA02,
..., PDAnn. Then you have to establish some relationship between this
strings and the data to be copied... suppose you have a Customers table to
be divided among the salesmen devices, you could set a 'subscriber'
nvarchar field to PDA01, PDA02, ..., PDAnn and then user a filter like
'subscriber = HOST_NAME()'

About encryption, since the connections are made contacting an agent thru
IIS, you can use HTTPS instead of HTTP.

--

Alberto Silva
Mobile Devices MVP @pt
http://msmvps.com/AlbertoSilva

"luke" <talktomyfriend@xxxxxxxxxxx> wrote in message
news:euaZTZcNHHA.1816@xxxxxxxxxxxxxxxxxxxxxxx
Hi Group,

I like have two of replications, one of them is to use merge replication
in [Upload Only] mode.

- What is the best practice for removing uploaded records?

- The other one I like to use download server's information to multiple
mobile devices which would have their individual data set from a common
table. Where do I set the filter to avoid data goes to wrong device?

- The last question is that how to make encrypted transaction over
internet for these data?


Thanks,

Luke






.

Relevant Pages

  • Joins and dynamic filters with different users
    ... I'm building an app for a software company that wants to ... put their desktop app on the pocket pc. ... I'd like to be able to filter data by user. ... having the customer have to configure Windows or SQL Server accounts for all ...
    (microsoft.public.sqlserver.replication)
  • Re: Fuel "polishing"
    ... I have a problem with the term "depth type filter" From the picture and ... With both pocket and pleated type filters the fuel only passes ...
    (uk.rec.waterways)
  • Re: how to register rtsp network source filter to wm2005 pocketpc device
    ... Please see the Pocket PC Mag Expert Blog at ... how to register rtsp network source filter to wm2005 pocketpc device. ... how to register custom streaming protocol, ...
    (microsoft.public.pocketpc)
  • Re: Directories ?
    ... especially not in Pocket PC. ... or role based secuity, and while a filter can be written that sits on the ... Prev by Date: ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Directories ?
    ... especially not in Pocket PC. ... > or role based secuity, and while a filter can be written that sits on the ... Prev by Date: ...
    (microsoft.public.dotnet.framework.compactframework)
Loading