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?
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?