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.
Please sign in to leave a comment.
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.
Just get two result-sets from these tables and compare them!