Click here to Skip to main content
12,630,420 members (30,723 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# .NET SQL-Server , +
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 20:59pm
Updated 19-Jan-13 21:30pm
v2
Comments
Zoltán Zörgő 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 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 20-Jan-13 12:02pm
   
thanks original griff I was expecting an answer from you only.

Regards

Varun
OriginalGriff 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.161205.3 | Last Updated 20 Jan 2013
Copyright © CodeProject, 1999-2016
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