Read millions of records from table

[mlauber71]

@VishalS one idea could be to load the data in chunks if you have an individual ID or something.

Download data from a database in chunks and append them to an CSV file –...

The other option could be to use streaming

Copy data from mysql to postgresql

@mgiammarco concerning the transfer you might want to think about streaming like in this example. Then depending on the database it might support UUIDs so you could create them in the DB, maybe after storing the table after transfer in a temporary table. Postgres seems to support uuids: The Basics Of PostgreSQL UUID Data Type Another option would be to create uuid in KNIME. You would have to see how to then insert them into the target DB