Copy data from mysql to postgresql

[mlauber71]

@mgiammarco concerning the transfer you might want to think about streaming like in this example.

Transferring data between databases – tobias.koetter

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.

Errors writing KNIME string to PostgreSQL uuid field

A solution could be something like this. You upload the file with the UUID into a emporary table and then insert it into the target table [image] The CAST() command would convert it into a uuid [image]

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

GUID Generator – sjporter