Custom Online Backup Solution Advice
- by Martín Marconcini
I have to implement a way so our customers can backup their SQL 2000/5/8 databasase online. The application they use is a C#/.NET35 Winforms application that connects to a SQL Server (can be 2000/2005/2008, sometimes express editions).
The SQL Server is on the same LAN.
Our application has a very specific UI and we must code each form following those guidelines. There’s lots of GDI+ to give it the look and feel we want.
For that reason, using a 3rd party application is not a very good idea.
We need to charge the customer on a monthly/annual basis for the service. Preferably, the customer doesn’t need to care about bandwidth and storage space. It must be transparent.
Given the above reqs., my first thoughts are:
Solution 1: Code some sort of FTP basic functionality with behind the scenes SQL Backup mechanism, then hire a Hosting service and compress-transfer the .BAK to the Hosting. Maintain a series of Folders (for each customer). They won’t see what’s happening. They will just see a list of their files and a big “Backup now” button that will perform the SQL backup, compress it and upload it (and update the file list) ;)
Pros: Not very complicated to implement, simple to use, fairly simple to configure (could have a dedicated ftp user/pass)
Cons: Finding a “ftp” only hosting plan is not probably going to be easy, they usually come with a bunch of stuff. FTP is not always the best protocol. more?
Solution 2: Similar to 1, but instead of FTP, find a cloud computing service like Amazon S3, Mosso or similar.
Pros: Cloud Storage is fast, reliable, etc. It’s kind of easy to implement (specially if there are APIs like AWS or Mosso).
Cons: I have been unable to come up with a service optimized for resellers where I can give multiple sub-accounts (one for each customer). Billing is going to be a nightmare cuz these services bill per/GB and with One account it’s impossible to differentiate each customer.
Solution 3: Similar to 2, but letting the user create their own account on Amazon S3 (for example).
Pros: You forget about billing and such.
Cons: A mess for the customer who has to open the Amazon (or whatever) account, will be charged for that and not from you. You can’t really charge the customer (since you’re just not doing anything).
Solution 4: Use one of the many backup online solutions that use the tech in cloud storage.
Pros: many of these include SQL Server backup, and a lot of features that we’d have to implement. Plus web access and stuff like that will come included.
Cons: Still have the billing problem described in number 2. Little of these companies (if any) offers “reseller” accounts. You have to eventually use their software (some offer certain branding).
Any better approach?
Summary: You have a software (.NET Winapp). You want your users to be able to backup their SQL Server databases online (and be able to retrieve the backups if needed). You ideally would like to charge the customer for this service (i.e. XX € a year).
