无需Internet连接即可连接到集中式SQL DB。 [英] Connect to centralized SQL DB without internet connection.

问题描述

亲爱的朋友，



我在为客户制作软件时遇到问题，有时互联网连接丢失。



由于SQL服务器数据库是集中式的，而且在某些偏远地区如果软件没有互联网（有些时候由于波动）那么怎么能我可以从软件中执行/执行条目或交易..



我制作的软件是基于桌面的。



请给予任何sugestions。



谢谢和问候



Varun Sareen

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

推荐答案

这不是一个容易回答的问题，解决方案太复杂了，无法在像这样的小文本框中处理。

然而，这是一个我们确实看到很多问题 - 这是销售人员在移动互联网之前曾经遇到的同样问题 - 并且有一个解决方案。它被称为 SQL复制，我担心它不像写这个那么简单 - 你有相当多的阅读要做。

从这里开始： https://www.google.co.uk/search?q=SQL+Replication&oq=SQL+Replication&sourceid=chrome&ie=UTF-8 [ ^ ]和按照一些链接 - 他们会给你一个概述，你可以从那里开始设计你的解决方案。

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.

这篇关于无需Internet连接即可连接到集中式SQL DB。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！