GNOME Bugzilla – Bug 567054
Merge two databases
Last modified: 2020-12-25 12:36:48 UTC
designed for people who is working with different computers and have data spared in several db files: this (replacing sqlite for sqlite3) http://osdir.com/ml/db.sqlite.general/2003-03/msg00229.html is good for not creating again every table (only created one time), but it doesn't manage the repeated IDs of every table entry the 'cat' command says: INSERT INTO "person" VALUES(34,'Xavi2','M','1/1/1900',0,-1,2,-1,0,'',-1,1,-1); SQL error: PRIMARY KEY must be unique read this: http://www.mail-archive.com/sqlite-users@sqlite.org/msg12675.html read also this for a coded aproach: http://www.mail-archive.com/sqlite-users@sqlite.org/msg12681.html also read this: http://marc.info/?l=sqlite-users&m=118294015331423&w=2 To merge tables this thread can be useful: http://www.mail-archive.com/sqlite-users@sqlite.org/msg27594.html