Offline/Online sync in Ionic 3 from SQLite to SQL Server

I am developing app that requires to store data in SQLite when internet connection is not available, but as soon as app get internet connection, data from SQLite to SQL Server should go automatically to SQL Server.

Is there any way I can accomplish this task?

I have SQLite for local storage and SQL Server at backend.

1 Like

you have to build your own logic for all of this and put it in an provider (ionic-angular).

  • detection of network
  • detecting changes and saving back and forth
  • conflict resolution strategy
  • secure storage locally - optional
  • tokenized login - optional

If you have found an out-of-the-box solution, plse post here, but I don’t think it is that easy.

I am looking to get some answers similar what’s mentioned in subject. How did your app go? what are the steps to achieve it. I am new to mobile development. any help, guidance will be appreciated.