You can use DB Data Difftective software/tool to compare and synchronize data in two databases.
DB Data Difftective is easy-to-use utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization. Oracle, MS SQL, IB/FB, MySQL, and PostgreSQL databases are supported.