Page 1 of 1

Schema Comparison 7.4.201 – identical objects shown as different

Posted: Thu 26 Apr 2018 08:56
by Sławek
Some identical tables are shown as different and there is no difference shown explicitly in the source/target split window and there is really no difference between the DDL scripts.

It does not occur in 7.2.78 (used for the same physical databases !)

Re: Schema Comparison 7.4.201 – identical objects shown as different

Posted: Thu 26 Apr 2018 09:43
by alexa
Could you please execute the queries below against the Source and Target servers and provide us the generated CREATE definitions for the tables you are experiencing issues with:

Code: Select all

SHOW CREATE TABLE <table_name>;
Also, please specify the versions of the Source and Target servers.

Re: Schema Comparison 7.4.201 – identical objects shown as different

Posted: Thu 26 Apr 2018 14:00
by Sławek
I found out that the DDL scripts of the tables concerned are different.

It means that my statement that they are identical was false.
Anyway, the statement was based on the identical content displayed in the source/target windows in the "Compare Schema" interface.

The conclusion is that there is a bug in 7.4.201 (I suppose it concerns also other 7.3 and 7.4 releases) causing displaying improper content for some objects.

Re: Schema Comparison 7.4.201 – identical objects shown as different

Posted: Fri 11 May 2018 08:06
by alexa
We would still need the CREATE definitions of the tables so we can reproduce the issue on our side.

Also, please specify the versions of the compared Source and Target servers.

You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .