Transfer data between Sqlite databases (FAST)

transfer.cmd

#Having sqlite command line installed from https://sqlite.org/download.html
sqlite3 destination.sqlite #open database
ATTACH origin.sqlite as orig #attach the origin database
.databases #see all databases
.tables #see all tables
BEGIN TRANSACTION
  INSERT INTO destTable SELECT * FROM orig.originTable;
END TRANSACTION;