using online, offline data

Question

1.00/5 (1 vote)

See more:

i have a situation where, i have multiple retail stores connected to a head office.
what i want is, if internet is working properly store should connect to head office and use data from there,
but as soon as the store goes offline, it should start using data locally.
after the internet starts again, it should connect to HO and start using data online.
i am using sql server 2008, .net 3.5

Any Suggestions

thanx in advance

SHailesh

Posted 7-Jul-13 19:59pm

mistryshailesh

Updated 7-Jul-13 20:10pm

v2

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Joezer BH** · Answer 1 · 2013-07-07T20:21:00

Hi SHailesh,

Technically there does not seem to be any issue here.
Your application will try connecting to the HO. If connection to the HO fails, connect to aux DB, local/other. There is no problem replacing a connection to the DB or keeping several connections in parallel.
* If you need examples, specify on which part. We'll be glad to assist with the already many code samples here in CP

However - what you do have to consider is the synchronization mechanism.
Once you go "online" again, (i.e. the application always keeps polling the HO DB to see if it manages to connect), there's the issue of data you have manipulated on the local aux DB (potentially several databases, and potentially from several locations etc) that has to be integrated into the HO DB.
This is more of a Business Logic layer issue though.

Good luck,
Edo

using online, offline data

1 solution

Solution 1

Add your solution here

Preview 0

using online, offline data

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us