3

In my application I want to send data stored in the local sqlite database to server's sqlserver database. Is there any utility for android to directly send the .db file and read the content in the server. Writing multiple insert statements will make code very lengthy and will cause in the primary key violation. Please help.

Improve this question
1
  • can u share the code. I am struck on the same process Commented Jun 25, 2014 at 9:44

1 Answer 1

Reset to default
5

When you create the database you are specifying the database name (for instance products.db). If your application package name is com.example.yourapplicationpackage, you can access the file using the path: /data/data/com.example.yourapplicationpackage/databases/products.db

Then you can send that file just like any other file to your server (use a POST request). On the server side, you need classes to read a SQLite 3 database file, this should not be hard to find.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Great comment. A follow up question: can you use this for backup/restore through the BackupAgent android facility? I'm trying to find the easiest way to backup/restore. The only problem I see with this is lock conditions. Ideas?
But you must be root, right? Is there a way to do it programmatically whithout having to be root?
@Flawyte afaik u can use external memory if the device supports

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.