[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    [sqlite] Transfer data between databases
From:       Pierre Chatelier <ktd () club-internet ! fr>
Date:       2009-01-09 8:18:09
Message-ID: EE5191D0-C3F0-4813-92C7-3D38DC9BE587 () club-internet ! fr
[Download RAW message or body]

Hello,

This may be a question with a very short answer...
I have two separate SQLite database files, but containing the same  
kind of tables. Is there a quick way to copy rows from one table of a  
file to the same table of the other file ?
I suppose "no", and I will have to perform SELECT on one side and  
INSERT on the other. But since one of my column is a blob type, it is  
a little more pain than a simple string copy, because for performance  
I should have to handle the blob with the read/write functions. Right ?

Anyway, are there tricks to know to make such a row transfert simple  
and efficient ?

Regards,

Pierre Chatelier
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]