Copy data from mysql to postgresql
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