Table and Schema Compare shows difference when identical

Answered

I am trying to create some migration scripts using DataGrip using the Compare functionality.  I have two databases that are currently identical.  I dropped the schemas on both and ran the same SQL to create the tables.  When I do a compare it tells me that the id column on each of my tables is different between the two databases in the top window but when I click on the column the lower panes say that they are identical.  The screenshot shows what I am talking about.  This is a compare on a table. If I do it for the schema it shows the id column for every table I have defined as different.  If I hit the apply left to right it gives me an empty script since they are identical.  When I have a lot of tables this is annoying since I have to scroll through the results to find the real differences.  Any ideas?

 

 

6 comments
Comment actions Permalink

I just ran the schema compare in IDEA against the same databases and schemas and it worked as expected and did not detect any differences.  I usually use DataGrip and IDEA at the same time so that I can keep my database and and other work separated due to open tab overload but I guess I will have to rely on IDEA for my migration scripts for now.

0
Comment actions Permalink

I am get the same when using DataGrip, pretty poor basis for selling a product when compare does not even work

do support not read these and help ?

 

 

 

 

0
Comment actions Permalink

DataGrip does not give me any functionality that I can't get elsewhere except that I have already paid for it.  I am investigating other options at this point.  If DataGrip had Postgres function debugging that would make it my top choice.

0
Comment actions Permalink

here is an answer from support...

We have found root cause of this issue - the difference in ID column 'nextval'. And we have fixed it already, I guess fix will be included in next update which is planned in next 3-4 weeks.

0
Comment actions Permalink

yes, this issue is fixed. please wait until next update.

0
Comment actions Permalink

SQL Server provides us with different solutions to replicate or archive a database table or tables to another database, or the same database with different names. If the data and schema of the two tables are identical or not. In this article, we will go through the different ways to compare the data and schema between two tables. The provided methods in this article will compare tables that are hosted in different databases, which is the more complicated scenario, and can be also easily used to compare the tables located in the same database with different names.

0

Please sign in to leave a comment.