[Bug 567054] New: Merge two databases

["chronojump (bugzilla.gnome.org)" <bugzilla-daemon bugzilla gnome org>]

If you have any questions why you received this email, please see the text at
the end of this email. Replies to this email are NOT read, please see the text
at the end of this email. You can add comments to this bug at:
  http://bugzilla.gnome.org/show_bug.cgi?id=567054

  chronojump | chronojump | Ver: unspecified
           Summary: Merge two databases
           Product: chronojump
           Version: unspecified
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: Normal
         Component: chronojump
        AssignedTo: xaviblas cvs gnome org
        ReportedBy: xaviblas cvs gnome org
         QAContact: xaviblas cvs gnome org
     GNOME version: Unspecified
   GNOME milestone: Unspecified


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


-- 
See http://bugzilla.gnome.org/page.cgi?id=email.html for more info about why you received
this email, why you can't respond via email, how to stop receiving
emails (or reduce the number you receive), and how to contact someone
if you are having problems with the system.

You can add comments to this bug at http://bugzilla.gnome.org/show_bug.cgi?id=567054.