Replication between Android and Sql Server

Question

I want to do the replication between sql server & android sqlite.I have done downloading(sql server to Android) using WCF service.Uploading part also that way I can do it.

My Problem is: After user change/enter table contents (e.g enter new invoice), it should start the upload(sqlite to sql sever) backed without effecting my current work/activity.

How we can implement this?

If it is mutithreading how it is possible.Need to run two activity same time.One will run foreground other one run in background....

Please help me or give me idea reading this?

Thanks in advance?

Answer 1

The recommended design practice for this is to use a content provider which handles concurrent thread access to the database.

To handle the background service actions, just implement an IntentService and simply call startService(intent);