Transfer Data Between Databases

Next command transfers data into the currently connected database from the specified databases using a reader query (executed on the from databases). The column names should match between the source and the target. There can be multiple source databases.
connect pos1
transfer into_table from pos2,pos3 using
select id, firstname, lastname from persons;

The transfer is running on configurable number of threads.

vset transfer.threads=4

Execute 'help' to see all configurable parameters.

There is one reader thread and multiple writer threads. Each writer thread is writing a bunch of rows, then it does COMMIT the transaction. The writer threads are writing between 500 and 100.000 records, depending on the number of columns which are transferred ( 500 for more then 50 columns, 100.000 for 1- 2 columns ).

Navigation