Need urgent help in Database update choice
- From: Philip Germanos <PhilipGermanos@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 18 Jun 2005 13:00:02 -0700
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: Joćo Paulo Figueira [eMVP]
- Re: Need urgent help in Database update choice
- Prev by Date: Re: SQL CE Database(.sdf) on device Unicode Character Problem
- Next by Date: SQL Server CE Connectivity Management Utility
- Previous by thread: Trouble in opening prior SQL CE database on SQL Mobile
- Next by thread: Re: Need urgent help in Database update choice
- Index(es):
Relevant Pages
|
Loading
