Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
How to sync a sqlserver database to dropbox
I am working on an application where a sqlserver database is centrally located on a dropbox server. The application that is resident on a pc connects to the dropbox database. At first I was thi...
Greg-DB
Dropbox Community Moderator
Dropbox Community ModeratorWhile you can store database files themselves, Dropbox and the Dropbox API don't offer a way to remotely connect to these database files to run database queries/operations. You'd need to download/upload the database file each time you need to change it. I'll send this along as a feature request though.
I can't speak much to if/how interacting with a local database file in the Dropbox folder would work though. If you do try to use a local database file synced in the Dropbox folder via the Dropbox desktop client, it's possible the database program and the Dropbox desktop client would prevent each from accessing the file when they're using it (e.g., when the database is open, or when Dropbox is trying to sync changes).
I can't speak much to if/how interacting with a local database file in the Dropbox folder would work though. If you do try to use a local database file synced in the Dropbox folder via the Dropbox desktop client, it's possible the database program and the Dropbox desktop client would prevent each from accessing the file when they're using it (e.g., when the database is open, or when Dropbox is trying to sync changes).
Thanks Greg.
I'm thinking the best way to do this then is to disable the autosync feature on dropbox for the folder. There is an app called Beyond Compare that has a scripting feature that is available. It does requiring registering it, which costs $35. It works well for backing up to Dropbox. Then it can be scheduled to synchronize through Windows Scheduler.
Ultimately I would love to automate it, but for the uses the companies would have their own way of backing up the files. So the best solution would be to keep it a manual solution.
Have a blessed Memorial Day,
Mike
About Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.
