Can we use Dropbox for sharing sql database in multiple computers?

Question

0.00/5 (No votes)

See more:

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.

Posted 15-Feb-14 20:16pm

Hadi IR

Updated 15-Feb-14 22:26pm

v3

Add a Solution

2 solutions

Solution 1

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!

Posted 15-Feb-14 21:41pm

OriginalGriff

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)

Hadi IR · Accepted Answer · 2014-02-15T21:53:00

Solution 2

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;

Posted 15-Feb-14 21:53pm

Hadi IR

Updated 15-Feb-14 21:58pm

v2

Comments

Kornfeld Eliyahu Peter 16-Feb-14 3:59am

Do not post your comment as a solution - use 'Have a Question or Comment?' button instead...

Hadi IR 16-Feb-14 7:00am

Sorry I am beginner in this site