我们可以使用Dropbox在多台计算机上共享sql数据库吗？ [英] Can we use Dropbox for sharing sql database in multiple computers?

问题描述

大家好;



我有疑问;我们想要开发一个用于公司三个领域的管理软件;办公室，工厂一和工厂二。



适用于每15分钟或每次用户需要更新的在线离线数据库。

的问题是：是否有可能将SQL数据库文件同步到Dorpbox并与其他用户共享同时使用sql数据库而没有任何冲突问题？



或最好的方法是在网络托管中心使用sql server？



这个软件可以在生产线;通过条形码阅读器跟踪生产进度;因此，对于单个sql server数据库来说，断开连接是不可接受的;

什么是带有主sql数据库的最佳在线离线解决方案？



我想在公司的每个独立部分;使用软件并在主题sql数据库中保存数据，如果连接到Internet，则保存对主机中主sql server的更改。

Hello every one;

I have a question; we want develop a management software that used in three areas of a company; office, factory One and factory two.

it is proper to apply online offline database that update every 15 mins, or every time that user want.
the question is : is it possible to sync SQL database file to Dorpbox and share with other users while use sql database at the same time without any conflict problem?

or the best way is use sql server in web hosting center?

this software will work in production line; with tracing production progress by barcode reader; So disconnection on internet is not acceptable for a single sql server database;
what is the best online offline solution with a main sql database?

I want in each separate part of company; use software and save data in themes sql databases and if connected to internet, save changes to main sql server in host.

推荐答案

使用SQL Server并从中访问相同的数据库通过单个实例的所有位置：不要试图让多个版本的SQL更新相同的数据库文件，除非你通过复制正确地做到这一点，否则会造成巨大的麻烦 - 这不是一个微不足道的主题，并且它打算用于本地复制数据库使用，例如salesdroid，它无法永久访问在线数据库并偶尔进行更新。



尝试跨多个SQL同步文件通过dropbox的实例将是一场灾难！

Use SQL Server and access the same DB from all locations via the single instance: don't try to have multiple versions of SQL update the same database file, it will cause massive hassles unless you do it properly via replication - which is not a trivial subject in any way, and it intended for "local copy" database use such as a salesdroid who doesn't have permanent access to the online DB and makes occasional updates.

Trying to sync a file across multiple SQL instances via dropbox would be a disaster!

感谢您的回复;



此软件将在生产线上运行;通过条形码阅读器跟踪生产进度;因此，对于单个sql server数据库来说，断开连接是不可接受的;

什么是带有主sql数据库的最佳在线离线解决方案？



我想在公司的每个独立部分;使用软件并在主题sql数据库中保存数据，如果连接到Internet，则保存对主机中主sql server的更改;

thank you for replying;

this software will work in production line; with tracing production progress by barcode reader; So disconnection on internet is not acceptable for a single sql server database;
what is the best online offline solution with a main sql database?

I want in each separate part of company; use software and save data in themes sql databases and if connected to internet, save changes to main sql server in host;

这篇关于我们可以使用Dropbox在多台计算机上共享sql数据库吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！