Sync local sqlite to server side sql server (like MySQL)?

Archived Forums Questions & Answers
1

Hi friends

I’m developing an iPhone App which will be used by a set of 50 odd people. The app will work in offline mode, do all the read/write operations from/to the local sqlite db. And when the internet connection is available it’ll sync the new changes to the server side MySQL database or in case if meanwhile the server side database has updated, then it should sync the changes from MySQL to sqlite and then push the new changes to the server side MySQL database.

I need a solution for bidirectional sync for sqlite<->mysql that works well with Unity. I’ll really appreciate any help.

Thanks in advance

1 Answer

1
2

One method would be you can send the data from your local sqlite database to the server in a format like JSON and then process that data and add it to your MySQL database on server. And you can also do this vice versa.