Hi, I have a mysql database in normal form with around 20 tables, with numerical id key. I need to copy data to a postgresql database, uuid based, that is similar but not identical to first one (it is a new version of the same application). I am a newbye of knime, I would like to understand if knime help me saving time or it is better to write some code. So I ask: has knime some nodes to help migrating from id to uuid? has knime some nodes to map columns for source table to destination table? is knime a good tool to save time for this job? Thanks, Mario

Copy data from mysql to postgresql

mlauber71 May 16, 2023, 5:12pm 5

@mgiammarco I would assume you would have to enter some constraints when creating the databases. You might have to test it.

PostgreSQL Constraints

PostgreSQL Foreign Key

Is it possible to just write the new data (rows) in Postgres DB?