SQLite database migration to Core Data with updating live version on App Store

Question

I have live application on the app store. It uses SQLite data storage and ugly methods that save and get data form it. I have replaced the data model with core data. So right now I have one table that contains favorites list. I suppose user will lose their favorites data, and the second problem will be that previous SQLite data base will be in the app.

What's the best way to migrate that data to new data base. So code was ugly, I have started to write new project. It means that there will not be any SQLite data base as before with the same name, just new Core Data db. How usually we need to solve this problem.

I think I can add a method in app delegate that will check if data base with name in the application I will try to retrieve all data from that storage and convert it to the Core Data entities. Then when data will be converted with success, I will drop that database. When I will if all my active users will have this update. I will remove this feature from app delegate because all will up to date. Does it make sense?

is your table dataStructure and relationship in tables going to be same or different? — Shashi3456643
– Shashi3456643, Commented Feb 13, 2015 at 14:52
@Shashi3456643, fortunately there are no relationships, but I think the structure of data model will be the same. But in this case I will use entity for favorites list. I even did some not maybe great things, So my Favorite entity has NSMutableDictionary as value that contains all information about entry. For current small structure it's ok. — Oleksandr Matrosov
– Oleksandr Matrosov, Commented Feb 13, 2015 at 15:55

Mundi · Accepted Answer · 2015-02-13 20:04:00Z

1

Your approach is correct. In the new app version, check if there is an up-do-date Core Data persistent store, if not, read the old data, copy it to Core Data, delete the old sqlite file.

You can leave that code in there for a long time - it just won't run if there already is a valid Core Data installation.

answered Feb 13, 2015 at 20:04

Mundi

80.3k17 gold badges119 silver badges142 bronze badges

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

Collectives™ on Stack Overflow

SQLite database migration to Core Data with updating live version on App Store

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related