If you are unsucessful dro me an email - I might be able to help (not a commercial proposition - just may help me doing some testing with my code)
Cheers Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 16 November 2016 at 15:31, Simon Slavin <slav...@bigfraud.org> wrote: > > On 16 Nov 2016, at 3:16pm, Andrew Stewart <astew...@arguscontrols.com> wrote: > >> Forgot to ask 1 thing. What is a quick way to copy an entire table >> from database1 to database2? > > If they are open in different connections you cannot do it. > > If they are open in the same connection using ATTACH then you can do it like > this: > > open ('new.sqlite') > ATTACH 'corrupt.sqlite' AS corrupt; > CREATE TABLE myTable (... same structure as the old one ...); > INSERT INTO myTable (SELECT * FROM corrupt.myTable) > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
