====== SQLite ======

===== Merge two databases =====

==== First method ====

<code>
attach 'second.db' as toMerge;           
BEGIN; 
insert into AuditRecords select * from toMerge.AuditRecords; 
COMMIT; 
detach toMerge;
</code>

==== Second method ====

<code>
$sqlite3 database1.db '.dump' >> tmp
$sqlite3 database2.db '.dump' >> tmp

$sqlite3 database3.db '.import tmp table1'
...
$sqlite3 database3.db '.import tmp tableX'

$ #sometimes sqlite3 database3.db < 'tmp' instead of last row
</code>