Database File In Drop Box Shared Folder

Can a software database file be saved and kept in a shared folder like drop box and be accessed and used (whether simultaneously or not) from more than one computers? A quickbooks database file is an example. Can it be centrally located on a dropbox folder and be accessed by a computer from another location getting the benefits of synced and up to date info?

Answer

Generally-speaking, no this will not work. Dropbox uses asynchronous replication. Unless the application is specifically designed with this use case in mind, your data will be hopelessly corrupted.

In the case of standard RDBMS engines, cooperation with the DB engine itself is required to implement reliable replication.

In short, very very rarely is replication as simple as copying files around (which is all Dropbox is doing).

Attribution
Source : Link , Question Author : Romain , Answer Author : EEAA

Leave a Comment