Iphone programming- Importing an existing sql table to sqlite or core data

Question

I have a simple table that I'm pulling from our existing sql database. Its just a 1mb Vehicle table. It contains enough information that I don't want to create it from scratch, but I can not find a definitive answer on how to import this table into my sqlite environment on the mac.

I've seen a few posts about python scripts that import to Core Data but I don't think thats the way to go.

The table I saved out as .rpt file. Any direction other than the one I'm traveling would be great.

bbum · Accepted Answer · 2011-01-27 15:52:19Z

1

The most correct (and pretty easy) way to do this is to write a little Mac OS X command line tool program that reads the data from your SQLite database and uses Core Data to load the data into a Core Data persistent store.

That persistent store -- the resulting Core Data schema'd SQLite file -- can be added as a resource to your iOS app project and it'll "just work".

answered Jan 27, 2011 at 15:52

bbum

163k23 gold badges276 silver badges360 bronze badges

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

Comments

Scott Ahten · Accepted Answer · 2013-04-11 01:47:41Z

0

Checkout Christian Kienle's Core Data Editor, which let's you import data from CSV files into Core Data: http://christian-kienle.de/CoreDataEditor

It is also useful after the data is imported for debugging.

answered Apr 11, 2013 at 1:47

Scott Ahten

1,1817 silver badges16 bronze badges

Collectives™ on Stack Overflow

Iphone programming- Importing an existing sql table to sqlite or core data

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related