Re: Need urgent help in Database update choice

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: URGENT: Application_Start - doesnt fire
    ... It's as if the Web site simply ignores ANY ... > changes I make once the exception is encountered for the first time. ... You never said what the exception was. ... How can I get the Web server itself to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: messages stuck and then released after exchange reboot
    ... any messages stuck in an outbox on the web or in outlook. ... checked with the users and the messages were delivered the first time. ... Both times the backend server was rebooted. ... All of the users were from the same exchange server. ...
    (microsoft.public.exchange.admin)
  • filesystem? "Failed to load module ..."
    ... This is the second time this symptom (Failed to load module "bitmap", ... first time, I had to re-install the OS from scratch. ... Before reporting problems, check http://www.XFree86.Org/ ... When reporting a problem related to a server crash, ...
    (RedHat)
  • Re: Server no longer on list
    ... Probably the Business Contact Manager that came with Office 2003, ... loads up in first time you use Outlook and you can then cancel it. ... PCs appear as a server. ... If you had a large domain with hundreds of SQL Server ...
    (microsoft.public.access.adp.sqlserver)
  • Re: alter table query not working after working at least once. MS SQL 2000
    ... constraint. ... server is MS SQL 2000. ... Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx- Hide quoted text - ... works again the first time. ...
    (comp.databases.ms-sqlserver)