是否有可能在没有网络连接的情况下为两个系统共享单个SQL [英] Is there any possibility of sharing single SQL for two systems without a network connecction

问题描述

是否有可能在没有网络连接的情况下为两个系统共享单个SQL



我尝试过：



i不知道该做什么，因为它与网络相关

Is there any possibility of sharing single SQL for two systems without a network connecction

What I have tried:

i have no idea of what to do as it is network related

推荐答案

让我们退后一步分析问题你正拥有的。你有两个系统，两者都需要共享SQL。我将假设你的意思是你有两个系统都需要访问同一个数据库。如果是这种情况，您真正需要做的是为SQL数据库设置一个中心位置，让系统或应用程序只需访问它们。



现在问题的下一部分是没有网络连接。根据之前解决方案中的注释，我将假设所讨论的应用程序或系统位于不同的物理位置，无法通过局域网（LAN）连接直接访问。您提到使用互联网和静态IP地址，因此这告诉我它们可通过世界区域网络（WAN）访问，也称为互联网。话虽如此，你有几个选择，我会从更糟的开始，然后转向理想。



第一个选项，手动移动数据。正如Mehdi Gholam所说，这是一个坏主意，所以我们不再接受它，然后将其作为一种选择。



第二种选择是公开的将数据库暴露给互联网并使用某种数据复制。这会让你面临很多安全问题和风险，我们只是停止谈论它。



第三种选择是创建一个Web服务（XML或RESTFUL） ）可在每个位置公开访问。它的唯一目的是在两个站点之间复制数据。这当然是可行的，但它涉及大量工作和精心规划，以确保安全性和数据完整性。有很多框架可以帮助解决这个问题，但是你需要做很多谷歌搜索，阅读和仔细的计划。



第四个选择是去使用托管数据库解决方案，例如Azure SQL数据库或Amazon RDS。这显然会花钱，但诚实地说，这将是您理想和最安全的解决方案。网上有很多可以帮助你实现这一目标的物资，只需准备好进行大量的谷歌搜索和阅读。



在旁注，我强烈建议你研究你的网络技能。您不需要成为网络专家，但对它们的基本了解将帮助您解决这个问题。

Let's take a step back and analyze the problem you are having. You have two systems and both need to share "SQL" as you put it. I'm going to assume that you mean you have two systems that both need to access the same database. If this is the case, what you are really need to do is setup a central location for the SQL database and have both systems or application simply access them.

Now the next part of your problem was "without network connection". Based on the comments in the previous solution, I'm going to assume that the applications or systems in question are located at different physical locations with no direct access via a local area network (LAN) connection. You mentioned using the internet and a static IP address, so this tells me that they are accessible via a world area network (WAN), also know as the internet. With that said, you have a few options here and I'll start with the worse and move to the ideal.

First option, manually move the data around. As Mehdi Gholam stated, this is flat out a bad idea and so we won't entertain it any more then stating it as an option.

Second option is to publicly expose the databases to the internet and use some sort of data replication. This opens you up to so many security concerns and risks, we'll simply just stop talking about it.

Third option is to create a web service (XML or RESTFUL) that is publicly accessible at each location. It's sole purpose is to replicate data between the two sites. This is certainly doable but it involves a great deal of work and careful planning to ensure security and data integrity. There are many frameworks out there that can assist with this, but you will need to do a lot of Googling, reading and careful planning.

The fourth option is to go with a hosted database solution such as Azure SQL Database or Amazon RDS. This is obviously going to cost money, but this honestly would be the ideal and safest solution for you. There is a lot of materiel on the web that can help you achieve this, just have to be prepared to do a lot of Googling and reading.

On a side note, I strongly recommend you work on your networking skills. You don't need to be an expert at networks, but a basic understanding of them will go a long way in helping you out with this problem.

没有连接就无法共享，甚至断开连接的同步数据都需要手动复制并确定更改的内容。



所有这些都不建议，并且手动非常困难。

You can't share without a connection, and even disconnected syncing data will require manual copying and determining what changed.

All of this is not advised, and is very difficult manually.

这篇关于是否有可能在没有网络连接的情况下为两个系统共享单个SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！