Re: Need urgent help in Database update choice
- From: "Alberto Silva - Mobile Devices MVP" <albertosilvaMVP@xxxxxxxxxxxxxxxx>
- Date: Sun, 19 Jun 2005 23:40:41 +0100
I haven't understood completely your 1st question: should they have
different sets of data? If so, you must of course define a way to
differentiate them.
The Merge Replication process takes care of it. To differentiate data
between the users with MR, you should use dynamic filters, defining a
different HostName property for each of them and definining an article
filter clasue that relies on the Host_Name() function.
--
Alberto Silva
Mobile Devices MVP @pt
http://msmvps.com/AlbertoSilva
"Philip Germanos" <PhilipGermanos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:D184C9E9-642E-4A0D-9AE6-651F5818BDED@xxxxxxxxxxxxxxxx
> Thanks Joao Paulo,
>
> But concerning question (2), how does the server differentiate the updates
> between users, in other words, suppose we have 3 users: u1, u2, u3 and the
> three of them have different updated data on their devices, how the server
> knows that u1 needs update1 and u2 needs update2 and u3 needs update3
> especially because all 3 users have the same authentication.
>
> Thanks a lot Joao Paulo.
>
> "João Paulo Figueira [eMVP]" wrote:
>
>> 2) Merge replication will do this for you automatically.
>> 3) You have to provide an external means of sending this info to the PDA.
>> One possible choice is to use SMS, otherwise your users will have to sync
>> frequently.
>>
>> --
>> João Paulo Figueira
>> Embedded MVP
>> http://nativemobile.blogspot.com/
>>
>> "Philip Germanos" <PhilipGermanos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
>> message news:F4788E5C-FEB6-446B-B809-D14ECB35F2C2@xxxxxxxxxxxxxxxx
>> > Hello,
>> > First of all, here's my application scenario: I have a pocket pc
>> > application
>> > with an sql ce db, the app only reads data from the db and displays it
>> > to
>> > the
>> > user, user cannot edit or delete data. From time to time, users needs
>> > to
>> > update the device db data from a central sql server 2000 db.
>> >
>> > Ok, so what i can use is either RDA or Merge/Replication, but my
>> > problem
>> > in
>> > finding the correct choice and how to use it resides in different
>> > points:
>> >
>> > 1)Users dont have username/password authentication, server wont know
>> > how
>> > to
>> > differentiate btw users, access to IIS will be anonymous and to sql
>> > server
>> > will be the same for all users(either windows or sql server
>> > authentication
>> > will be stored in the application)
>> > 2)In either choice of updates, the first time i connect to the server,
>> > the
>> > db schema and the whole data will be transferred to the device, but
>> > after
>> > the
>> > first time, how to just update the updated data of the server and not
>> > the
>> > whole server db data.
>> > 3)In either choice of updates, how the application will know that an
>> > update
>> > exists?
>> >
>> > Any advice or help?
>> >
>> > Thank you.
>> >
>> >
>>
>>
>>
.
- Follow-Ups:
- Re: Need urgent help in Database update choice
- From: Philip Germanos
- Re: Need urgent help in Database update choice
- References:
- Need urgent help in Database update choice
- From: Philip Germanos
- Re: Need urgent help in Database update choice
- From: Joćo Paulo Figueira [eMVP]
- Re: Need urgent help in Database update choice
- From: Philip Germanos
- Need urgent help in Database update choice
- Prev by Date: Re: Scroll Bars in datagrid
- Next by Date: Re: Need urgent help in Database update choice
- Previous by thread: Re: Need urgent help in Database update choice
- Next by thread: Re: Need urgent help in Database update choice
- Index(es):
Relevant Pages
|
