After two weeks of with my bride (for 26 years), it's time to get back to work.
I have a two part problem:
* I want to take snapshots of my Salesforce on demand. My primary need is to backup the data.
* I do not want another database/application infrastructure to maintain.
Using the libraries from SQLForce, I have taken a stab at a the problem (called CopyForce) that introspects any SalesForce instance and creates a local database that matches the Salesforce schema/data. So far the only database back-end I have used is H2 (a good alternative to Apache/Derby).
Any takers for beta testing? The source is open at http://code.google.com/p/sqlforce/
Back to my inbox...only 89 message to go;-)