Android SQLite: what is the best way to create a copy of database

Question

What is the best way to create a copy of all data from database A in database B using SQL (and not a file copy)?

Community · Accepted Answer · 2017-05-23 10:08:26Z

1

There is two approach check which one you prefers. but I think if possible i will follow first approach. But I have never done it.

First Approach Copy the first database and paste with some othername see following url

How to copy existing database from one app to another

Second Approach copy the contents of two database

Step-1 First Attach two databases

ATTACH DATABASE filename AS database-name;

The DATABASE keyword is optional, but I like the clarity of it. filename should be the path to the database file you wish to attach, and the database-name is a unique name.

Step-2 Run Insert Into commands for the tables you want to transfer.

INSERT INTO X.TABLE(Id, Value) SELECT * FROM Y.TABLE;

edited May 23, 2017 at 10:08

CommunityBot

11 silver badge

answered Dec 16, 2011 at 6:40

Sunil Kumar Sahoo

53.7k55 gold badges182 silver badges244 bronze badges

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

1 Comment

Asahi Over a year ago

The first approach suggest file copy which is not what I am looking for. As for the second one - can you please give a bit more detailed example (code snippet perhaps)? Thanks

Collectives™ on Stack Overflow

Android SQLite: what is the best way to create a copy of database

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related