Re: Need urgent help in Database update choice

No, they all have the same DB Schema, but what I meant by different data, I
will describe it in this simple example: Suppose I have 3 users: u1, u2 and
u3. On the first update(update1), u1 and u2 update their data, u3 doesnt.
After a while a second update is made on the server(this update is added to
the first publication), all three updates, how does the server knows that u1
and u2 just needs the second update and u3 needs the whole publication?

Note: There is no authentication of users, they connect to IIS anonymously
and then to sql server using windows authentication.

Please explain, thank you.

"Alberto Silva - Mobile Devices MVP" wrote:

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

Relevant Pages

  • Re: Need urgent help in Database update choice
    ... To differentiate data ... how does the server differentiate the updates ... >>> 2)In either choice of updates, the first time i connect to the server, ...
    (microsoft.public.sqlserver.ce)
  • Re: how to catch custom errors raised in SP gracefully?
    ... sending error messages back and forth across the wire is a good idea. ... Anything that can be handled on the server should be, ... >differentiate my custom error from the raw SqlExceptions (like table is ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: manipulating query strings
    ... i.e URL manipulation? ... > I know I can pass variables in URL to Server side script variables ... The server will differentiate between GET and POST, ...
    (Pen-Test)
  • New Master Shapes Bounding Box
    ... I've created a new "Serch Server" shape based on the nice isometric ... icon to differentiate it from eg web server or email ... grouping and ungrouping all the shape elements and I've tried amending ...
    (microsoft.public.visio)