Re: Offline Data Synchronization

Tech-Archive recommends: Fix windows errors by optimizing your registry

Design solution highly depends on subject area, environment where the app
will work, etc.

What I can tell you for sure is that you will have to have somekind of
applicatin cache, that will store data when laptop is off network.
Then detect when network appears and flush data into the database.

To resolve conflicts ( when data was changes by 2 offline laptops and after
that they become online ) you can introduce the notion of timestamps.
Then you can introduce some logic, comparing timestamps.

Also you can introduce some remote endpoint. Laptops will communicate with
this endpoint ( service or smth else ) and it in its turn will communicate
with Db server.

--
Vadym Stetsyak aka Vadmyst
http://vadmyst.blogspot.com

"Fenno" <paul@xxxxxxxxxxxxx> wrote in message
news:1133411032.050955.28920@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> One of the requirements of a development project I am working on is for
> end users to be able to take their laptop off the network and do work
> on the application (VB.NET win-forms app with SQL Server database).
>
> Then at some time later, the user should be able to come back into the
> office, re-connect to the network and everything they've done will
> synchronize with the main SQL Server database.
>
> I have been trying to find some design patterns relating to this, but
> no luck. Does anyone know any good articles on this topic. Or better
> still, a design pattern?
>
> Thanks in advance
>


.

Relevant Pages

  • RE: Domain vs Wkgrp changed VB app launch
    ... You had a problem with the VB app at home because apparently it needs something from ... installed on the laptop but rather accessed over the workplace network. ... The installer prompted that I was attempting to ...
    (microsoft.public.win2000.networking)
  • Re: Domain vs Wkgrp changed VB app launch
    ... if you notice in "book:)" the laptop was ... not connected to the network at work. ... The VB app ran fine, ... > then they could have told you about creating a separate hardware profile ...
    (microsoft.public.win2000.networking)
  • Review my resume. Please.
    ... communication, interpersonal, and problem solving skills. ... MOST and CAN (Controller ... network devices for automotive industry based on MOST (Media Oriented ... the Open Systems Interconnect reference model; design focused ...
    (comp.arch.embedded)
  • Re: FAA: Boeings New 787 May Be Vulnerable to Hacker Attack
    ... determination if that design is compliant with the rules (14 CFR Part ... Special Conditions: Boeing Model 787-8 Airplane; ... network architecture is used for a diverse set of functions, ...
    (rec.aviation.piloting)
  • Re: Is AI all about time?
    ... The "high level thinking" network is NOT A DIFFERENT TYPE OF NETWORK from ... "I think it will be possible to build strong generic learning ... ALL REINFORCEMENT LEARNING PROCESSES INCLUDE BEHAVIOR ... us the ability to design. ...
    (comp.ai.philosophy)