Connect to centralized SQL DB without internet connection.

Question

2.50/5 (2 votes)

See more:

, +

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

Varun Sareen

Updated 19-Jan-13 20:30pm

v2

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

OriginalGriff · Answer 1 · 2013-01-19T21:39:00

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.