Android - SQLite Database - App update

Question

So I got a sqlite database (version 7) which stores data for my App (version 1.0) and I want to fix a few bugs (that have nothing to do with my database). What happens if I update my App to version 1.1? will the data be deleted? or will it just be deleted if i update the databse version to 8?

(My onUpgrade in the databasehandler will delete the existing databse and create a new one by the way)

Community · Accepted Answer · 2017-05-23 12:28:44Z

2

Upgrading an app does not do anything to the database. Old data files are kept intact.

Changing the version number in code for your SQLiteOpenHelper will cause onUpgrade() to be called if the version number in the database file is lower. That by itself doesn't delete anything, but if you yourself delete the data (as you say), then it is lost.

See also: When is SQLiteOpenHelper onCreate() / onUpgrade() run?

edited May 23, 2017 at 12:28

CommunityBot

11 silver badge

answered Mar 6, 2014 at 11:30

laalto

153k68 gold badges293 silver badges306 bronze badges

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

Comments

GangaNaidu · Accepted Answer · 2014-03-06 11:38:34Z

0

Data will delete if you change the version, but in onUpgrade method we have two parameters

called oldVersion and newVersion. we can do what ever we want by checking old new version

condition.

answered Mar 6, 2014 at 11:38

GangaNaidu

1946 bronze badges

Collectives™ on Stack Overflow

Android - SQLite Database - App update

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related