Devart Forums

Hi,

I am writing to ask about the trial version of MySQL Schema Compare. I'm planning to buy the MySQL bundle, so I'm trying the program features.
I am receiving a false positive for command line schema compare (sensitive information removed):

Started at: 2/12/2015 15:49:06.
Command line: /schemacompare /source host:XXXXX user:XXXXX password:XXXXX database:XXXXX /target host:XXXXX user:XXXXX password:XXXXX database:XXXXX /sync:dumps/XXXXX.sql /ForceColumnOrder:Yes /IgnoreAutoIncrement:Yes /IgnoreAvgRowLength:Yes /IgnoreColumnDefaultValues:No /IgnoreDefiner:Yes /IgnoreEndsClause:No /IgnoreForeignKeys:No /IgnoreStartsClause:No /IgnoreTableEngine:No /IncludeComparisonSettings:No /IncludeIdenticalObjects:No /SelectedObjectsOnly:No

Connecting to XXXXX : 0...
Connecting to XXXXX : 0...

Specifies source with the following options:

Database
Host = XXXXX : 0
Database = XXXXX
Server version = 5.6.21

Specifies target with the following options:

Database
Host = XXXXX : 0
Database = XXXXX
Server version = 5.6.21


Mapping objects...
Describing objects...
Comparing data...

Summary:
-------------------------------------------------------------------------------
== Identical 274
<> Different 22
>> Only in Source 0
<< Only in Target 0
?? Unknown 0
xx Inconsistent 0

Type State Name
-------------------------------------------------------------------------------
Tables
<> XXXXX
<> YYYYY
<> ZZZZZ
<> XXXXX
<> YYYYY
<> ZZZZZ
<> XXXXX
<> YYYYY
<> ZZZZZ
<> XXXXX
<> YYYYY
<> ZZZZZ
<> XXXXX
<> YYYYY
<> ZZZZZ
<> XXXXX
<> YYYYY
<> ZZZZZ
<> XXXXX
<> YYYYY
<> ZZZZZ
<> XXXXX

-------------------------------------------------------------------------------

Synchronizing objects...
-------------------------------------------------------------------------------
Alter table "XXXXX"
Alter table "YYYYY"
Alter table "ZZZZZ"
Alter table "XXXXX"
Alter table "YYYYY"
Alter table "ZZZZZ"
Alter table "XXXXX"
Alter table "YYYYY"
Alter table "ZZZZZ"
Alter table "XXXXX"
Alter table "YYYYY"
Alter table "ZZZZZ"
Alter table "XXXXX"
Alter table "YYYYY"
Alter table "ZZZZZ"
Alter table "XXXXX"
Alter table "YYYYY"
Alter table "ZZZZZ"
Alter table "XXXXX"
Alter table "YYYYY"
Alter table "ZZZZZ"
Alter table "XXXXX"

Synchronization successfully done.

Finished at: 2/12/2015 15:51:32.





But the generated SQL file contains only a "use XXXXX" statement.
I also noted that command line tool is not tracking "ON DELETE" and "ON UPDATE" statements from foreign keys.



Please note that this is just the start of a batch action of comparing 1000 databases. So the GUI is not an option for me.


Thank you in advance,
Everton Moreth

To reproduce this issue, we would need the following information:

1. Version of dbForge.
2. CREATE definitions of the tables that you are experiencing the issue with for both the Source and Target.
3. Please check and let us know if it doesn't work when using the GUI of dbForge as well as the command line interface.