Recommended (remote) backup technique for SQL Compact?
Posted
by Cool Jon
on Stack Overflow
See other posts from Stack Overflow
or by Cool Jon
Published on 2010-05-05T01:51:07Z
Indexed on
2010/05/05
1:58 UTC
Read the original article
Hit count: 461
Hello.
Is there a generally recommended approach to backing up an SQL CE/SQLite database over the Internet? The client source is .NET/Windows based, the backup destination runs Ubuntu.
I am using a small SQL CE database and have been trying to figure out the most reasonable approach to doing this. The file size (in terms of transfer time/bandwidth) isn't a big deal. I had a look around, and so far the things I've given thought are:
- Online backup services (Dropbox, Mozy)
- Opening an FTP/SFTP connection
- Writing a custom protocol with public/private keys
Unsure regarding #1 because I doubt they would like it if somebody transferred gigabytes of data using a POST; and they do not seem to offer native (or .NET) APIs.
FTP/SFTP seems risky in terms of security and privileges (as the password/key would need to be stored on the client side). With the right user group/user privileges this may work.
Custom protocol seems overkill, which is why I am hoping somebody has already defined a reasonable API for language/platform-independent backups over the Internet.
Any hints S.O.?
© Stack Overflow or respective owner