From:       To:      
Home > Documentation > DB2 to MySQL

Merging DB2 data into the MySQL database

DB2-to-MySQL merges IBM DB2 data into MySQL 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 MySQL table. Otherwise, all DB2 rows are just appended to the target table.

If structure of DB2 and MySQL tables are not conformed, the converter tries to make every row fits to MySQL table structure and fires error when failed.

Have questions? Contact us