Dropbox SQL Sync Windows App
Budget: $750 – $1,500 AUD
I need a lightweight Windows desktop application that keeps local Microsoft SQL Server databases in step with a master copy stored in Dropbox. Each time we export a fresh SQL dump (or .bak) into a dedicated Dropbox folder, the app should:
• Detect the newest file, download it, and restore/overwrite the user’s local database.
• Record and display the exact date-and-time of the last successful sync on the main screen.
User management is simple but essential. New users create an account with email and password; those credentials must be validated against a small admin-managed list stored centrally (a table in the same master DB or a lightweight cloud file is fine). If I mark an account as deleted in the admin panel, that user’s local database files should be removed automatically the next time they attempt to sync.
Admin utilities I expect inside the same executable (or a separate companion tool if cleaner):
• List, add, disable, or delete users.
• Trigger a forced resync for any user.
Security matters, yet I don’t have a fixed requirement on algorithms—use standard best practice (TLS with Dropbox API, AES at rest, hashing + salt for passwords, etc.).
Tech stack is up to you, though I picture C# /.NET (WinForms or WPF) talking to the Dropbox API SDK and SQL Server via SMO or sqlcmd. I’m open to alternatives as long as they run on Windows 10/11 without extra licensing costs.
Acceptance criteria
1. One-click sync pulls the latest dump from Dropbox and restores it locally without manual SQL scripts.
2. The main window clearly shows “Last synced: <timestamp>”.
3. Admin can deactivate a user; that user’s next sync erases their local DB and blocks further access.
4. Clean installer and concise README so my team can deploy the app company-wide.
Let me know which libraries you’d leverage for Dropbox and SQL restore, plus an outline of your approach to user authentication and rollback handling.
• Detect the newest file, download it, and restore/overwrite the user’s local database.
• Record and display the exact date-and-time of the last successful sync on the main screen.
User management is simple but essential. New users create an account with email and password; those credentials must be validated against a small admin-managed list stored centrally (a table in the same master DB or a lightweight cloud file is fine). If I mark an account as deleted in the admin panel, that user’s local database files should be removed automatically the next time they attempt to sync.
Admin utilities I expect inside the same executable (or a separate companion tool if cleaner):
• List, add, disable, or delete users.
• Trigger a forced resync for any user.
Security matters, yet I don’t have a fixed requirement on algorithms—use standard best practice (TLS with Dropbox API, AES at rest, hashing + salt for passwords, etc.).
Tech stack is up to you, though I picture C# /.NET (WinForms or WPF) talking to the Dropbox API SDK and SQL Server via SMO or sqlcmd. I’m open to alternatives as long as they run on Windows 10/11 without extra licensing costs.
Acceptance criteria
1. One-click sync pulls the latest dump from Dropbox and restores it locally without manual SQL scripts.
2. The main window clearly shows “Last synced: <timestamp>”.
3. Admin can deactivate a user; that user’s next sync erases their local DB and blocks further access.
4. Clean installer and concise README so my team can deploy the app company-wide.
Let me know which libraries you’d leverage for Dropbox and SQL restore, plus an outline of your approach to user authentication and rollback handling.
Related categories:
.NET
SQL
C# Programming
WPF
Microsoft SQL Server
API
Dropbox API
Database Management