It is a java utility to perform table/data comparison between Oracle and PostgreSQL.

dbcompare.conf file can be used to change settings e.g. Oracle and PostgreSQL connection information.

dbcompare utility provide multiple command line options to facilitate the user.

This option can be used to specify multiple schemas e.g. -s schema1 schema2 s3.

Use this option to show the background activities e.g. SQL queries with time stamp.

The utility can be executed on unix/linux as following i.e. ./dbcompare.sh -s schema1 schema2

It will create 6 CSV files as pg_*.csv and ora_*.csv for Tables, Views and Materialized views in the following format i.e. table_name,row_count,index_count

These generated files can be compared with diff or similar utilities.

(C) 2022 OSCG-PARTNERS. All rights reserved.