On 9 June 2010 18:58, Scott Frankel <fran...@circlesfx.com> wrote: > > On Jun 9, 2010, at 12:22 AM, Vivien Malerba wrote: > >> 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 ;" > > While Libgda looks very interesting, I need a solution that's > accessible from common Linux, OSX, and Windows base installs.
Libgda (and associated tools) is available for those 3 OSes. Regards, Vivien _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users