Hi Simon,
For structure, all is in "select sql from master_sqlite", the big subtility
is to play them in a pertinent order.
For the data themselves, it is already done in the source sqlite.exe for
the ".dump" function, so I have just to digg .
Apparently , it's in shell.c around line 1275 .
"if( c=='d' && strncmp(azArg[0], "dump", n)==0 && nArg<3 ){"
... maybe not so complex ...
I suppose, for my simple wish case, I can omit the SAVEPOINT/RELEASE and
PRAGMA writable_schema=ON parts
(https://www.mail-archive.com/[email protected]/msg27037.html)
There is some obscure things in the code I don't know what it is, so I will
suppose they don't exist :
'sqlite_sequence'
WHERE tbl_name LIKE shellstatic()
Regards,
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
