B4J Question Fastest way to read from a db1 table and write to a db2 table?

[amorosik]

What is the fastest way to read from a db1 table and write to a db2 table?
I have a procedure which is normally connected to a Firebird db, one of the tables is "articles"
From B4j code I would like to read the information contained in some rows of the "articles" table and write them to the "articles2" table of a Sqlite db
The structure of the two tables is identical
Is it possible to do this with one query hit or do you need to loop through and copy row by row?

 

[JohnJ]

I know that in DB2 I can insert values into a table using a select on another table like this

insert into table2 (value1,value2,...) select value1,value2,... from table1 where

or

insert into table2 select * from table1 where

 

[amorosik]

I am trying with the following query but so far without success

db_file_name ="C:\test\db_sqlite.db"
SELECT * INTO ARTICOLI2 IN [ODBC;Driver={SQLite3 ODBC Driver};Database=C:\test\db_sqlite.db] FROM ARTICOLI

 

[JohnJ]

I am trying with the following query but so far without success

db_file_name ="C:\test\db_sqlite.db"
SELECT * INTO ARTICOLI2 IN [ODBC;Driver={SQLite3 ODBC Driver};Database=C:\test\db_sqlite.db] FROM ARTICOLI

Look at this.

Backup SQLite DB with VACUUM INTO

Less of a tutorial, more to point out another option which doesn't seem to have a mention anywhere on here yet.... I was searching for options to create a backup copy of an SQLite database. There are already options detailed here, and here, for example. But another option that seemed quite...

www.b4x.com

 

[amorosik]

That is correct sintax

SELECT * INTO ARTICOLI2 IN [ODBC;Driver={SQLite3 ODBC Driver};Dsn=Db_Sqlite;Database=C:\test\db_sqlite.db] FROM ARTICOLI