Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# .NET SQL-Server-2008
Dear Friends,
 
I am facing a problem while making a software for client where sometimes the internet connection gets lost.
 
As the SQL server DB is centralized, and at some remote areas if the software doesn't have the internet (for some times due to fluctuation) then how can i be able to do/perform the entries or transactions from the software..
 
The software I am making is desktop based.
 
Kindly give any sugestions.
 
Thanks & Regards
 
Varun Sareen
Posted 19-Jan-13 19:59pm
Edited 19-Jan-13 20:30pm
v2
Comments
Zoltán Zörgő at 20-Jan-13 2:30am
   
It depend on how the remote areas depend on on each-other. If the action on one site is affecting any other site in a manner that can not be handled during connection outage, than you probably won't be able to meet their requirements. And this on it's hand depend on how long an outage takes.
Since if there occur outages of maximum several minutes, and that can be tolerated by the process, than it looks solvable. So, please give us more details.
Varun Sareen at 20-Jan-13 11:54am
   
Thanks zoltan for your time..actually i was thinking also the same that there is no way to tackle this problem of working in disconnected environment as this is not feasible in this case as the outing may last up to several minutes.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

This is not an easy question to answer, and the solution is far too complex to deal with in a little textbox like this one.
However, it is a problem that we do see a lot - it's the same problem that sales guys used to have before mobile internet - and there is a solution. It's called SQL Replication and I'm afraid it is not as simple as "write this" - you have a fair amount of reading to do.
Start here: https://www.google.co.uk/search?q=SQL+Replication&oq=SQL+Replication&sourceid=chrome&ie=UTF-8[^] and follow a few of the links - they will give you an overview and you can start designing your solution from there.
  Permalink  
Comments
Varun Sareen at 20-Jan-13 12:02pm
   
thanks original griff I was expecting an answer from you only.
 
Regards
 
Varun
OriginalGriff at 20-Jan-13 12:09pm
   
You're welcome!

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 395
1 Maciej Los 268
2 OriginalGriff 230
3 CHill60 221
4 Sibeesh KV 139


Advertise | Privacy | Mobile
Web01 | 2.8.141022.2 | Last Updated 20 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100