Using in CoreData an SQLite database created in a non CoreData app
Using in CoreData an SQLite database created in a non CoreData app
- Subject: Using in CoreData an SQLite database created in a non CoreData app
- From: Alexander Lamb <email@hidden>
- Date: Mon, 7 Aug 2006 14:05:02 +0200
Hello list,
I managed to export some data (Access) to an SQLite3 database on
Windows (after setting the legacy_file_format PRAGMA for MacOSX
compatibility) through an ODBC adaptor.
Now I have this SQLite3 database on MacOSX I would like to use as a
data store/source for a CoreData application.
It doesn't work because:
1) The CoreData metadata is missing
2) The table names don't match.
For point 1, I suppose I could create in CoreData an empty database
and copy over the Z_METADATA table to the new database.
I suppose I should do the same for all the Z_PRIMARYKEY tables. Is
that correct, suitable?
How can I map the tables, since CoreData seems to create Znameoftable
instead of nameoftable.
Can I explicitly tell CoreData "this entity is this table" (as in
EOF) or is my only option the change of the table name. If so, is
there an easy way in SQLite3 to rename a table?
More generally, this seems a rather generic task "recuperate for
CoreData an external database". Is there a documentation covering
this aspect somewhere?
Thanks,
Alex
--
Alexander Lamb
email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden