Android Question Download MySQL to SQLite data by RDC

[dhernandez]

Hi all, I have a question for you.
How do you to copy data from a remote database (MySQL) and insert it into my device in SQLite?
My SQLite has the same fields MySQL

Thanks in advance-...

 

[giga]

I would first download the data as a CSV(Comma Separated Value) file.

You could use this as a backup, but also as possibly to read from and insert into SQLite.

 

[dhernandez]

There will be no way to create one in config.properties select_data line = "SQL statement" to look for me and me the data inserted from Remote to Local?
Just as is done by inserting SQLite to MySQL ...
using Remote Database Connector

 

[Erel]

Create a query that downloads the complete table and then add the data to the local database.

Make sure to create a single transaction when adding the data.