DB2-to-PostgreSQL merges IBM DB2 data into PostgreSQL tables using the following approach. If both source and destination tables define primary key or an unique index, the tool inserts rows having key values that do not exist in PostgreSQL table. Otherwise, all DB2 rows are just appended to the target table.
If structure of DB2 and PostgreSQL tables are not conformed, the converter tries to make every row fits to PostgreSQL table structure and fires error when failed.
Have questions? Contact us