Comparing multiple tables in Datagrip

Hi, In Datagrip, there is a feature to detect differences between 2 similar tables from 2 different databases (Table view > Compare With).

I need to process this comparison over all tables of the databases:

My use case is to compare the dev DB and prod DB to see if the reference datas are consistent. A report showing the differences per table would be nice.

2 comments
Comment actions Permalink

One way to do what you want is:

1) Export the one or more tables as CSV or TSV or HTML or plain text (.txt).

2) Use Beyond Compare ( https://www.scootersoftware.com/features.php?zz=features_list ) to perform the comparison and make a printed and/or HTML comparison report. Beyond Compare understands tables (CSV, tab delimited, HTML tables, and Excel worksheets), making it easy for you to do what you want.

0
Comment actions Permalink

Just get two result-sets from these tables and compare them!

0

Please sign in to leave a comment.