How to convert an sqlite 2 database into an sqlite 3 database

8 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.

1. Ahmed says

   Hello!

   I tried this way and it seems to work good, but for a unicode database table fields !! I think that part didn’t work right. So, any Ideas to solve such problem?

   Thanks.

   October 28, 2007, 3:45 am
2. lazloman says

   Where can I get sqlite2? It doesn’t appear to come with the version distro, at least not for Gentoo.

   July 8, 2008, 8:26 pm
3. John says

   Like, you know, the internet man.

   July 12, 2008, 2:20 pm
4. Xephandor says

   Sometimes, some distros call sqlite to sqlite2. Try that.

   Oh, and I think you can do something like this:

   sqlite path/to/olddb .dump | sqlite3 path/to/newdb

   January 17, 2009, 8:29 pm
5. Bobo says

   Hallo @lazloman
   try this
   http://www.sqlite.org/sqlite-2_8_17.zip
   http://www.sqlite.org/sqlitedll-2_8_17.zip

   March 3, 2009, 2:22 pm
6. Real Hike says

   I search in Internet and see that all asked how to convert sqlite 2 to sqlite 3. I need vise versa operation! Please do anybody knows how to convert sqlite 3 to sqlite 2? I use SQLite under Windows XP. Thank you.

   September 21, 2009, 7:20 am
7. Miguel Ferreira says

   Real Hike: just do the same, but swap sqlite2 to sqlite3:

   sqlite3 path/to/olddb .dump > backupfile
   sqlite2 path/to/newdb < backupfile

   January 15, 2010, 2:17 am
8. Randy says

   I tried this but I think the autoincrement in the primary key of the original database is causing an issue with the import.

   July 21, 2010, 12:48 pm