Export remote XML DB files and store in SQLite DB to use by android app

I have ac开发者_Go百科cess to a set of remote XML files stored in a server (XML files of a MySql database tables). I have to import and create my own SQLite BD to use them with the android mobile app. When remote XML files update(When MySql database information change), the SQLite DB also Should change accordingly.

Can any one guide me how to accomplish this task this.

Sample coding/ reference/ Idea highly appreciated.

1.Download and Parse the XML files 2.Store them in SQLite database 3.Write a background scheduled service which executes the code for corresponding the above 1 and 2. Or Use the Cloud to Device message from your server to the android app to update your SQLite database(but I thought the above 1 and 2 points may need here also.It is all about your logic how you develop the application).

You can try my xsl template http://code.google.com/p/mysql2sqlite-xslt/.