Can you merge two sqlite databases on the iPhone?

Question

Well the question says it all. Is there an easy way to merge two sqlite databases on the iPhone? Their structure is identical and the primary key is guaranteed to be unique across the two databases.

I know you can do a INSERT INTO SELECT, but I was wondering if there is a more elegant solution.

Answer 1

I haven't checked it thoroughly, but maybe you'll find something in: Core Data Model Versioning and Data Migration Programming Guide. It's included in the Xcode documentation, so you probably already have it.

EDIT: I'm just offering a starting point, not a verified solution.