Re: [OpenGuides-Dev] sqlite performance and migration?
6 Oct
2004
6 Oct
'04
1:06 p.m.
On Wed, Oct 06, 2004 at 12:48:57PM +0100, David Cantrell wrote:
I'd define the tables in the new db but without foreign key constraints or indices; then for each table, select all the rows from the sqlite db and insert into the new one; finally, turn the constraints and indices on
The usual caveats about SQL dialects and portability apply, of course.
It would be really excellent if someone could write a set of scripts for doing this for CGI::Wiki databases and this script could be included in CGI::Wiki. Cheers, Dominic.
7832
Age (days ago)
7832
Last active (days ago)
0 comments
1 participants
participants (1)
-
Dominic Hargreaves