How to sync Sqlite Database with Remote Database?

sync remote database (mysql) with sqlite database and vice versa

• In my android app I need to sync SQLite database with remote database (mysql) and vice versa.... the concept is something like when application launches application should sync database from remote database.. when I perform some action data should save into sqlite and then sync it to remote database.. Please guide how to perform this task. Thanks in advance....

• Answer:

  you can write an android http://developer.android.com/reference/android/app/Service.html which can be called when the applicaiton starts. this service will start http://lukencode.com/2010/04/27/calling-web-services-in-android-using-httpclient/ in the background while the application can fetch data from the http://www.vogella.de/articles/AndroidSQLite/article.html. UPDATE here is a sample http://ashwinrayaprolu.wordpress.com/2011/03/16/custom-content-provider-in-android/ for database.