On 8 June 2010 22:02, Scott Frankel <fran...@circlesfx.com> wrote: > > On Jun 8, 2010, at 12:51 PM, Jean-Christophe Deschamps wrote: > >> >>> What's the best way to copy data from one db to another? >>> >>> Given 2 databases with identical schemas, one full of data and the >>> other empty, the brute force way would be to perform selects on the >>> source db, then for each row, perform an insert into the destination >>> db. Is there a more efficient way? >> >> The easiest is either to simply copy the file as Igor suggested or use >> the backup API (very easy too). > > I forgot to mention, the source is a PostgreSQL db, not SQLite, so > there's no source file to copy. Though a backup might be > interesting ...
You can use Libgda's gda-sql tool in which you can: * open a connection to the PostgreSQL db (for example named db1) * open a connection to the SQLite db (for example named db2) * bind those 2 connections into a 3rd one, and execute statements like "insert into db2.table_one_name select * from db1.table_one_name ;" If you want more info, tell me. Regards, Vivien _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
