Hi Ulrik,
thanks for your reply. The way you describe sounds reasonable. If there is no such tool, yet, I will do it. I just thought that this could be a general tool interesting for many people, as in my understanding it does not depend at all on the content/scheme of the database.
Stefan
On Sat, 12 Feb 2005 11:42:06 +0100 (CET), Ulrik Petersen <[EMAIL PROTECTED]> wrote:
Hi Stefan,
Hi,
I have released a new version of my task tracking software Yatt. It's based on SQLite. The new version adds a bunch of new features including user management from the html interface. You can find it on www.yatt.de. It's freeware.
It's currently using SQLite 2.8.x. I am thinking about upgrading to 3.1.x.
Is there
an automated tool for converting a database from 2.8 to 3.1, which I could
give to
users for simplifying the upgrade? I mean a tool, which opens the old
database, reads
the scheme, creates a new database and copies all entries. Or do I have to
build
something myself? I know this can be done from the commandline, but that's
not an
option for normal users - especially on windows, I think.
I don't think it would be hard to do yourself. Here's how:
1) Extract the code for the ".dump" meta-command from shell.c in SQLite 2.8.15.
2) Make a program that consists of: a) The code extracted in (1) b) SQLite 2.8.15. c) The latest SQLite3 d) Some glue code
As far as I know, SQLite 2.8 is supposed to be able to co-exist in the same binary as SQLite3.
Otherwise, why don't you supply a .bat file that does the job? It can, of
course, be run from within your program.
HTH
Ulrik Petersen
