Schema Comparison Tool Showing Target Changes With Identical Tables.

[Terry D.]

Hi all,

I'm running a trial of SQLYog and made my first use of the schema comparison tool, today. I wanted to double check that a Testing DB's schema was the same as a copy I was working on. The tool showed two changes on the target (Testing) instance and generated the appropriate SQL. The trouble is the definitions, to me, are identical; even down to the column ordering (see attached).

Is there something I'm missing here?

Both servers are MySQL 5.1.57 on Amazon RDS. SQLYog is v 9.20.

Terry.

[peterlaursen]

As far as I can see the columns order is not identical on source and target. Schema Sync will also consider columns order and sync to identical columns order. Am I right?

If not you will have to provide a 'non-obfuscated' dialog along with CREATE TABLE statement for the table at both ends. If you do not want to do in public here you may create a prviate ticket by mailing to [email protected].

[Terry D.]

'peterlaursen' wrote:

As far as I can see the columns order is not identical on source and target. Schema Sync will also consider columns order and sync to identical columns order. Am I right?

If not you will have to provide a 'non-obfuscated' dialog along with CREATE TABLE statement for the table at both ends. If you do not want to do in public here you may create a prviate ticket by mailing to [email protected].

Hi Peter,

Sorry for the obfuscation, it's a matter of policy that we mask this stuff. I compared dumps of the two tables and found that they were indeed in a different order; so the changes listed and the resulting query are in fact correct, it's just that the dialog isn't displaying them in the order they're found.

Does this count as a bug or is it behaving as intended? (I'll send the dumps and screenshot to your support address for comparison)

Terry.

[peterlaursen]

We will reply in the private ticket you created!

[Author]

Posts