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.

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 ( ) 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.

Comment actions Permalink

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


Please sign in to leave a comment.