Getting remote database data into local database in android

We want to ge开发者_Python百科t 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.

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

Get desired data from mysql ...in the form of xml from server. Parse that xml in android and fill desired java beans inside collection. then write state of object's in collection to sqlite dataabase.

I would suggest next time providing some code that indicates at least that you attempted to connect to your database first, and then if you run into trouble, someone here may be able to help. As opposed to just asking for sample code.

If you're talking about replication, I'm not sure this is possible from SQL Server to SQLite, otherwise, the answer to your question is simple, you would connect to your SQL Server database probably through some sort of exposed API, retrieve the data, parse it, and update your local SQLite Database accordingly.

Here's a link to a tutorial that covers connecting to local databases: NotePad Tutorial