Hi Bernie, On Wed, 12 Sep 2007 07:59:25 -0400, you wrote:
>I'm just restarting a long dormant project that uses SQLite [also >converting it from being CGI-driven to being a self-contained Perl/Tk >app]. I've discovered that my old database, which is likely sqlite2, >won't open in the world of sqlite3 [duh!!]. I looked through the wiki >and around the sqlite.org website and I hoped to find a 2->3 conversion >tool, but I didn't see one. > >Any recommendations on how to effect the conversion. I see that >there's a command-line tool for reading sqlite 2 DBs, so I guess I >could do some sort of dump/export or something like that with that and >then use an sqlite3 command line tool to import it. ??? > >Thanks! /bernie\ sqlite your.db2 .dump | sqlite3 your.db3 The download page lists both versions of the command line tool. http://www.sqlite.org/download.html Regards, -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
