I am developing an android application which have
- SQLite on the mobile
- MS SQL on the Windows server
I want the mobile data to sync with the MSSQL database whenever a new entry is added. The sync data should remain in the mobile and work even if the mobile internet is offline.
The MSSQL database will have two identical (same fields structure and fields name)
I need to develop synchronization between these DB in one way.
The mobile application doesn't have any options for editing.
If I change data from server then it should change data in android
Sync will run the first time the application is started plus I will like to provide a sync button.
How do I sync databases in Android?
I have found several things but I am at beginners level. I didn't find any samples. I tried the "http://programmerguru.com/android-tutorial/how-to-sync-remote-mysql-db-to-sqlite-on-android/" tutorial but it uses php and MSSQL.
I will appreciate if some one will give me some sample code with some explanation or something like that which will show me a way to do this.