Skip to content

Latest commit

 

History

History

README.md

DBCOMPARE

It is a c# (.net) utility to perform table/data comparison between Oracle and PostgreSQL.

Configuration

app.config is a XML configuration file can be used to change settings e.g. Oracle and PostgreSQL connection information.

Options

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

schemas (-s)

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

verbose (-v)

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

Run

The utility can be executed as following i.e. dotnet DBCompare.dll -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.

Licence

(C) 2022 OSCG.IO. All rights reserved.