sql server - Getting remote database data into local database in android

Question

We want to get the remote database data into local database first and then we want to access the local database. Can you please suggest us how to approach for this with sample code. Our remote database is MSSQL Server.

Answer 1

Have the app query the remote server, return the data from MSSQL to android code via JSON, insert into SQLite.

Edit: type MySQL to MSSQL