> Given that they both use SQL, there's got to be a better way of doing > this. Could I, for example, simply get the remote server to do an SQL > dump and throw this at SQLite without horribly compromising security? > Are there any streamlined (i.e. fast) replication data formats I could > use? Has anyone done anything like this who can suggest anything?
A SQLite database is contained in a single file. I suggest trying this: 1. Grab a copy of the database off the device using adb pull or something 2. Whip up an activity that downloads that file off your server and stores it in the local file store (openFileOutput()) 3. Try using SQLiteDatabase#openDatabase() with the full path to the file, and see if you can work with it If that all works, you can do the MySQL->SQLite conversion on your server, where you have a wee bit more horsepower. -- Mark Murphy (a Commons Guy) http://commonsware.com _The Busy Coder's Guide to Android Development_ Version 1.2 Published! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
