Re: Need urgent help in Database update choice

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.
> >
> >
>
>
>
.

Relevant Pages

  • Re: Strange Server Behaviour
    ... Thanks for updates. ... I am Charles the backup of Brandy, as the Brandy is currently sick at home. ... Microsoft CSS Online Newsgroup Support ... | Subject: Re: Strange Server Behaviour ...
    (microsoft.public.windows.server.sbs)
  • Re: WSUS Client not yet reported
    ... The client still fails to report. ... Check your server status ... Suggestion 2: Check the IIS settings: ... any updates in your thread. ...
    (microsoft.public.windows.server.sbs)
  • Re: SUS
    ... > I have setup a SUS Server on win2k. ... 0-2.reg will not configure your machine to automatically download updates from ... critical updates or service packs that your machine needs. ... It will also ask you if you want to install them, ...
    (microsoft.public.windows.server.general)
  • Re: FYI for eTrust AV 7.x Users
    ... When I just had my little incident with the redistribution settings on the SBS, my clients were logging successful checks for updates, and the logs indicated that no updates were found. ... That turned out to be because I had not gone back and checked the redistribution server box for 8.x after reinstalling the redistribution server. ... installed the new remote install utility which works the same as v7 did - just edited the .ICF file the way I wanted it and ran the client upgrades from the server. ... I can't remember if it's a separate install, or if you have to click a box when you do the Agent install, but redistribution server is not installed by default. ...
    (microsoft.public.windows.server.sbs)
  • Re: Give yourself SQL Administrator rights
    ... Even if you change the default settings to allow updates to ... permissions to this user on sysxlogins. ... Only members of the server roles sysadmin and serveradmin ... SQL Server DBAs may wish to disable 'allow ...
    (microsoft.public.sqlserver.security)