DataGrip - Comparisons

Answered

A couple questions about comparisons:

 

  • When I do a schema compare (comparing two schemas), I just get a spinning wheel on the first object being compared (a synonym in this case); nothing else happens.  Any ideas on what the problem could be? 

 

  • I don't see a way to compare data in two tables in different schemas - is that possible?

 

Thanks

3 comments
Comment actions Permalink

@Kimreyj
> 2 Compare data
As a workaround,  you can invoke 2 queries to get data you need and compare result sets

> 1 Schema comparison
Could you specify database you use and provide sample DDL to reproduce the issue?

0
Comment actions Permalink

I'm using Datagrip 2021.2.4 to connect to a Microsoft SQL Server 2012 database. I cannot see "Compare Content" option as shown here: https://www.jetbrains.com/help/datagrip/tables-compare.html#compare-two-tables 

Is there another way to compare data between 2 tables?

0
Comment actions Permalink

You need to select 2 tables (with CTRL+click) before.

1

Please sign in to leave a comment.