Macaw has asked for the wisdom of the Perl Monks concerning the following question:
Hi Folks,
I need to sync a dozen or so smaller tables in Greenplum (Postgres) with their counterparts in DB2. I could write some code using DBI, but I was wondering if there was already something out there that was proven by others as being worthy of using.
Many databases have the option to dump tables to a CSV style file (and import from them). You may want to check your databases do; if they do, that seems an obvious way to me.